CountryWolf07
07-16-2007, 12:41 PM
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.
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.