Thread: simple diplay
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Govind
 
Posts: n/a
Default 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