Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

I need an excel formula

Posted on 2011-03-01
6
Medium Priority
?
202 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

704 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