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.
2007-07-26 03:25:35 · 4 answers · asked by tonda_web_designer21 2 in Computers & Internet ➔ Programming & Design
This is for Microsoft Excel, not a programming language.
2007-07-26 03:34:26 · update #1
=if(S3=F4*5,"OK","Not OK")
Understand that the comma after 5 means when the test is true, print OK..........the second comma means,"Otherwise" (the test is false), print Not OK.
2007-07-26 03:34:11 · answer #1 · answered by ed 7 · 0⤊ 0⤋
=if(S3=5*F4,"OK","Not Ok")
The wording of the question is a little unclear in when you say "5 times greater" If that means exactly, then use an "=" in the conditional, otherwise use a ">".
This function should be placed in cell P8
2007-07-26 10:34:45 · answer #2 · answered by Dilbert's Desk 5 · 0⤊ 0⤋
if ((S3*5)>F4)
then P8 = "OK"
else
then P8 = "Not OK"
endif
using fortran terminology. convert to whatever language you're using.
oops...wrong...
let me edit..perhaps someone else will beat me to it...
Good luck!
2007-07-26 10:32:34 · answer #3 · answered by Dennis R 5 · 0⤊ 0⤋
=IF(S3=5*F4,"OK","Not OK")
2007-07-26 10:33:21 · answer #4 · answered by Joan S 2 · 0⤊ 0⤋