?
Solved

How do I make a cell a text value based on whether another cell is negative or positive number in MS Excel

Posted on 2011-03-09
6
Medium Priority
?
163 Views
Last Modified: 2012-05-11
Hello,
I have a spreadsheet with a column (a2) with a variety of - and + values...I want to make column (b2) a text value of either "follow" for a -ve value or "lead" if a +ve value.

Thanks for your assistance.
Groovymonkey
0
Comment
Question by:groovymonkey
  • 2
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:Frank
ID: 35083106
IIF (a2>0,"lead","follow")
0
 
LVL 4

Accepted Solution

by:
Frank earned 1050 total points
ID: 35083110
paste this in b2 exactly so:
=IIF (a2>0,"lead","follow")
0
 

Author Comment

by:groovymonkey
ID: 35083224
Actually it is my F2 column that I am referencing in the actual sheet...I tried

=IIF (F2>0,"lead","follow")

and I am gettnig an error

this works though.,...
=IF(F2>0,"Follow","Lead")

thanks for the help
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 19

Assisted Solution

by:MINDSUPERB
MINDSUPERB earned 450 total points
ID: 35083433

Access uses IIF function and Excel uses the IF.

How about if F2 is blank or 0? What would be in B2?

Sincerely,
Ed
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35083502
Groovymonkey,

You can modify the formula as shown below to leave the cell blank if F2 is Blank or 0.

=IF(OR(F2="",F2=0),"",IF(F2>0,"Follow","Lead"))


Ed
0
 

Author Closing Comment

by:groovymonkey
ID: 35117745
Solution was slightly off...initially but we got there with help from another member (slight syntax issue for excel)
0

Featured Post

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.

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.

Join & Write a Comment

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.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

589 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