IF function

  • Thread starter Thread starter Bob J
  • Start date Start date
B

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
 
=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
 
Back
Top