Write an IF function for cell H3 that assigns the value of cell A7 to cell H3 if the value in cell J7 is less that the value in cell Q2; otherwise, have the IF function assign zero (0) to cell H3.
2007-07-25 03:31:10 · 6 answers · asked by tonda_web_designer21 2 in Science & Mathematics ➔ Mathematics
This is clearly a piece of homework. It almost tells you the answer.
2007-07-25 03:39:33
·
answer #1
·
answered by Hynton C 3
·
0⤊
0⤋
"if the value in cell J7 is less that the value in cell Q2"
means you start with
=IF(J7
Now, after that first comma you put what's to go in the cell if this statement is true, so it's
=IF(J7
To complete, after the second comma put what's to go in the cell if the statement is false, and then close the parentheses:
=IF(J7
This is math? Hm.
2007-07-25 10:38:17
·
answer #2
·
answered by Michael P 4
·
0⤊
0⤋
write this into cell H3:
=IF(J7
In cell H3, put
=IF(J7
Here, letters and numbers are free, but you can fix them or some of them with $ if you need.
2007-07-25 10:36:57 · answer #3 · answered by Steiner 7 · 0⤊ 1⤋
Enter this formula at H3:
2007-07-25 10:36:20
·
answer #4
·
answered by dansinger61 6
·
0⤊
1⤋
=if(j7
IF J7
ELSE
H3=0
END IF
2007-07-25 10:40:28 · answer #5 · answered by 037 G 6 · 0⤊ 0⤋
in H3 .... =((J7< Q2)*A7)
2007-07-25 10:42:01 · answer #6 · answered by Indiana Frenchman 7 · 0⤊ 0⤋