IF function

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
 
J

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

greatest value function? 2
Conditional formatting for time 1
Cause formulae totals to reflect negative and positive amount inpu 7
cell formula for using progressive information in other cells 5
Help with If Statement 3
Writing an IF Function 1
Depedent Dropdown and INDIRECT($P$8) with a twist 4
Adding numbers and text 6

Top