Solved

I need an excel formula

Posted on 2011-03-01
6
179 Views
Last Modified: 2012-08-14
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).
0
Comment
Question by:wrt1mea
  • 3
  • 2
6 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 35007954
Do you mean in a single row? For row 2

=(C2="Closed")

format result cell as %

regards, barry
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 250 total points
ID: 35007963
Sorry should have +0 at the end......

=(C2="Closed")+0

barry
0
 
LVL 1

Author Comment

by:wrt1mea
ID: 35007991
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 1

Author Comment

by:wrt1mea
ID: 35008021
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
 
LVL 1

Author Closing Comment

by:wrt1mea
ID: 35008050
Works great!
0
 
LVL 6

Expert Comment

by:Eric Zwiekhorst
ID: 35008055
Hi

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

This should do

Kr

Eric
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question