Printable View
Two problems; how do you exactly do this?
1) Write an IF function for cell H3 that assigns the value of cell A7 to cell H3 if the value in J7 is less than the value in cell Q2; otherwise have the IF function assign zero (0) to cell H3.
2) 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 Q2; otherwise, have the IF function assign the text, "Not OK" to cell P8.
It should be something like this:Quote:
1) Write an IF function for cell H3 that assigns the value of cell A7 to cell H3 if the value in J7 is less than the value in cell Q2; otherwise have the IF function assign zero (0) to cell H3.
In H3, type =IF(J7<Q2, A7,"0")
In P8, type =IF(S3=(5*Q2),"OK","Not OK")Quote:
2) 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 Q2; otherwise, have the IF function assign the text, "Not OK" to cell P8.
I did not check if the formulas work. You can look in the Excel Help for explanation about the IF function and conditional formulas.