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

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

You can use the formula:
=IF(I5<=G33,H33,IF(I5<=G34,H34,IF(I5<=G35,H35,IF(I 5<=G36,H36,H37))))
in cell J5.

As for converting hours to minutes, you can multiply the hours with 60 to
get the answer in minutes, but you have not specified what you want to
convert. The values in column G are not read as minutes by excel but are
simple numbers.

Mangesh



"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