YES/NO Result

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hello,

Hope someone can help me on this one!

Is it possible to display YES or NO in a cell if a result in another cell is
a positive o negative result

Ie: cell a1 to show YES if cell b1 has a positive number or NO if it is a
negative figure (this is going to be a currecy amount)

Thanks

Andy
 
Andy,

Try something like

=IF(B1>=0,"YES","NO")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Andy

In A1 enter =IF(B1>0,"yes","no")

OR if you consider 0 to be negative......

=IF(B1=<0,"no","yes")

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Is it possible to display YES or NO in a cell ...

I'll just be different. :>)

=SIGN(B1)

and custom format with
"Yes";"No";"Unknown"
 
Back
Top