simple diplay
 

Hi All

I need a formula for if A1 is greater than B1 or if A1 is equal to 0,
then “OK”, otherwise display “Not OK”

Simple but I cant work it out


please help

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=502348

simple diplay
 

Hi,

=IF(OR(A1B1,A1=0),"OK","NOT OK")

Regards

Govind.

koba wrote:
Hi All

I need a formula for if A1 is greater than B1 or if A1 is equal to 0,
then “OK”, otherwise display “Not OK”

Simple but I cant work it out


please help

Andrew

simple diplay
 

thanks,,,,,


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=502348