HELP PLEASE

K

Keith

The values in Column G are minutes so I may need to also know how to
convert hours to total minutes to make the formulas work.
 
D

Doug

Try

=IF(I5<=30,H33,IF(AND(I5>30,I5<=45),H34,IF(AND(I5>45,I5<=60),H35,IF(AND(I5>6
0,I5<=90),H36,H37))))

for the second part. You might have to explain that hours to total minutes
thing if it is still a problem.

Doug

Keith wrote in message ...
 
S

Sandy Mann

Not meant as a criticism. If I5<=30 then it will not reach the second IF
test so the "I5>30" is superfluous because if must be greater than 30 to get
to that point. Your formula can therefore be shortened to:

=IF(I5<=30,H33,IF(I5<=45,H34,IF(I5<=60,H35,IF(I5<=90,H36,H37))))


Regards

Sandy
 
Top