YES/NO Result

[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

 

[Don Guillett]

this?
=IF(F5<1,"N","Y")

 

[Chip Pearson]

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)

 

[Gord Dibben]

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

 

[Andy]

A big than you! Youv'e solved my last problem which itself was quite simple!

Thanks

 

[Dana DeLouis]

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"