I need an excel formula

I need an excel formula to look in column C for "Closed." If its closed, I need the formula to return 100%. If its not closed I need it to return 0 (zero).
LVL 1
wrt1meaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
barry houdiniConnect With a Mentor Commented:
Sorry should have +0 at the end......

=(C2="Closed")+0

barry
0
 
barry houdiniCommented:
Do you mean in a single row? For row 2

=(C2="Closed")

format result cell as %

regards, barry
0
 
wrt1meaAuthor Commented:
Barryhoudini,

It is for a single column. When I use your formula, its just returning tru or false (even though it still makes the computation) I need it to show either 100% or 0%. That way when the managers look at it, they know they need to pay attention to the 0 percents.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
wrt1meaAuthor Commented:
OK, the plus zero seems to have worked. i was originally trying to use an IF statement but didnt get very far.Thanks for the Information.
0
 
wrt1meaAuthor Commented:
Works great!
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
Hi

=IF(ISNUMBER(SEARCH("Closed",C:C;1)),100,0)

This should do

Kr

Eric
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.