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.

"Keith" wrote:

In Excel 2002 I have the following table;
Column G Column H
Row 33 30 $1.05
Row 34 45 $1.00
Row 35 60 $0.95
Row 36 90 $0.85
Row 37 120 $0.79

What I want to do with this is if the value in I5 is 1-30 I want the value
from H33 put in J5, if the value in I5 is 31-45 I want the value in J5 to be
H34, if the value in I5 is 45-60 I want the value in J5 to be H35, if the
value in I5 is 61-90 I want the value in J5 to be H36, and if the value in I5
is 91 or greater I want the value in J5 to be H37.

Can you please help me with this?
Thanks,
Keith

Try

=IF(I5<=30,H33,IF(AND(I530,I5<=45),H34,IF(AND(I5 45,I5<=60),H35,IF(AND(I56
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 ...

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.

"Keith" wrote:

In Excel 2002 I have the following table;
Column G Column H
Row 33 30 $1.05
Row 34 45 $1.00
Row 35 60 $0.95
Row 36 90 $0.85
Row 37 120 $0.79

What I want to do with this is if the value in I5 is 1-30 I want the
value
from H33 put in J5, if the value in I5 is 31-45 I want the value in J5 to
be
H34, if the value in I5 is 45-60 I want the value in J5 to be H35, if the
value in I5 is 61-90 I want the value in J5 to be H36, and if the value
in I5
is 91 or greater I want the value in J5 to be H37.

Can you please help me with this?
Thanks,
Keith

Not meant as a criticism. If I5<=30 then it will not reach the second IF
test so the "I530" 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

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Doug" wrote in message
...
Try


=IF(I5<=30,H33,IF(AND(I530,I5<=45),H34,IF(AND(I5 45,I5<=60),H35,IF(AND(I56
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 ...

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.

"Keith" wrote:

In Excel 2002 I have the following table;
Column G Column H
Row 33 30 $1.05
Row 34 45 $1.00
Row 35 60 $0.95
Row 36 90 $0.85
Row 37 120 $0.79

What I want to do with this is if the value in I5 is 1-30 I want the
value
from H33 put in J5, if the value in I5 is 31-45 I want the value in J5
to
be
H34, if the value in I5 is 45-60 I want the value in J5 to be H35, if
the
value in I5 is 61-90 I want the value in J5 to be H36, and if the value
in I5
is 91 or greater I want the value in J5 to be H37.

Can you please help me with this?
Thanks,
Keith