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

=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

=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

On Fri, 8 Feb 2008 19:40:01 -0800, Bob J <Bob
wrote:

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