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

Hi,

=IF(OR(A1>B1,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
>
>

thanks,,,,,