[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

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

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
groovymonkey
Asked:
groovymonkey
  • 2
  • 2
  • 2
2 Solutions
 
FrankBusiness OwnerCommented:
IIF (a2>0,"lead","follow")
0
 
FrankBusiness OwnerCommented:
paste this in b2 exactly so:
=IIF (a2>0,"lead","follow")
0
 
groovymonkeyAuthor Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
MINDSUPERBCommented:

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
 
MINDSUPERBCommented:
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
 
groovymonkeyAuthor Commented:
Solution was slightly off...initially but we got there with help from another member (slight syntax issue for excel)
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now