if statements

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.
 
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
 
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
 
J

JulieD

Hi

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.
 
Top