D
Don Guillett
Try looking in HELP index for OR and then for IF and put together. If you
still need help, post again and you will get help.
still need help, post again and you will get help.
M
M. Stanley
I'm trying to use an if statement and I'm not sure how to write it... here's
what i want to accomplish:
If cell H17 is blank or equal to 0 OR if G17-H17=0 then make cell I17 equal
to zero, OTHERWISE multiply G17-H17 by 1.5
I'm sure a nested IF statement would get the job done, but I'm not sure how
to do it... plz help. TIA
M. Stanley
what i want to accomplish:
If cell H17 is blank or equal to 0 OR if G17-H17=0 then make cell I17 equal
to zero, OTHERWISE multiply G17-H17 by 1.5
I'm sure a nested IF statement would get the job done, but I'm not sure how
to do it... plz help. TIA
M. Stanley
R
Rob
This should get the job done for you, place this formula in cell I17
=IF(H17=0+OR((G17-H17)=0),0,(G17-H17)*1.5)
Regards
Rob
=IF(H17=0+OR((G17-H17)=0),0,(G17-H17)*1.5)
Regards
Rob
J
JulieD
Hi
in cell I17 enter
=IF(OR(ISBLANK(H17),H17=0,G17-H17=0),0,(G17-H17)*1.5)
Cheers
JulieD
in cell I17 enter
=IF(OR(ISBLANK(H17),H17=0,G17-H17=0),0,(G17-H17)*1.5)
Cheers
JulieD
M
M. Stanley
If I had been able to figure out how to do this using Excel's help then I
wouldn't have posted the question, since that's where I always look first...
Next time you might try offering some real help instead of stating obvious
advice.
wouldn't have posted the question, since that's where I always look first...
Next time you might try offering some real help instead of stating obvious
advice.
M
M. Stanley
Thanks Rob and JulieD... that worked beautifully! 
D
Don Guillett
Yes SIR!!!!