IF function

[Bob J]

how would i write an if function for cell P8 that assigns the text "OK" if
the value in cell S3 is five times greater than the value in cell F4;
otherwise, have the if function assign the text "NOT OK" to cell P8

 

[Jim Cone]

=IF((S3/5)>=F4,"OK","NOT OK")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Bob J"
wrote in message
how would i write an if function for cell P8 that assigns the text "OK" if
the value in cell S3 is five times greater than the value in cell F4;
otherwise, have the if function assign the text "NOT OK" to cell P8

 

[Gord Dibben]

=IF(S3=F4*5,"OK","NOT OK")

Note: if F4 and S3 are both blank, you will get an OK

Trapped..........=IF(AND(S3="",F4=""),"",IF(S3=F4*5,"OK","NOT OK"))


Gord Dibben MS Excel MVP