I am having trouble entering these problems. I have a ton of these problems. If I could just see how to do one, I would be able to do the rest. Thanks for any help:)
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 than the value in cell Q2; otherwise, have the IF function assign zero (0) to cell H3.
2007-03-26 05:15:05 · 6 answers · asked by trinitarianwiccan 2 in Computers & Internet ➔ Software
your questions does not make senses what are your problems i just enter in the #s or what ever and tab to next one
2007-03-26 05:24:14 · answer #1 · answered by Anonymous · 1⤊ 0⤋
It's been a while since I've had to do this, but give it a try.
H3=A7 IF J7
I'd appreciate knowing if this worked or if I was close. Thank you.
2007-03-26 12:29:24 · answer #2 · answered by TheHumbleOne 7 · 0⤊ 0⤋
I have created the excel sheet for you as you requested.
Please send me an email via my account stating an email address I can send to work to you.
Trust me this is easier than typing out the coding and you will probably understand it better.
The code I got to work to be placed in Cell H3 is:
=IF(J7<=O2,A7,"0")
All the best
Moose
2007-03-26 12:25:27 · answer #3 · answered by Chεεrs [uk] 7 · 0⤊ 1⤋
The answer to your question is
=IF(A7
if you intend to copy/paste the formula you may need to determine if you have to lock a cell (this is done by adding a "$" in front of the Column or Rown....example...to lock Q2, you write $Q$2).
Hope this helps.
2007-03-26 14:13:12 · answer #4 · answered by Andres C 2 · 0⤊ 0⤋
Paste this into the H3 function area. It should do the trick. This assumes less than only and not = to.
2007-03-26 12:29:46
·
answer #5
·
answered by v0ice0freez0n 3
·
1⤊
1⤋
=IF(J7
mantra
2007-03-26 12:26:30 · answer #6 · answered by riko_smh2002 1 · 0⤊ 0⤋