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?

[Webinar] Streamline your web hosting managementRegister Today

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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
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
All Courses

From novice to tech pro — start learning today.