range calculation help
 

I am not sure if I can do this in excel, but here is what I am trying to do.

If have several value ranges (i.e 0-50, 51-100,
101-500,501-1000,1001-2000,2001-3000,3001-10000). I want to have excel check
a value (1) to determine if it falls between these ranges, and if it does,
return another number defined (2), and multiply the orig. number by the
number provided (i.e 1X2).

Example: A1:0, A2:51 A3:101 A4:501 A5:1001 A6:2001 A7:3001
B1:50 B2:100 B3:500 B4:1000 B5:2000 B6:3000 B7:10000
C1:5.6 C2:4.2 C3:4.05 C4:3.85 C5:3.70 C6:3.50 C7:3.15
F1:356
I want to check what F1 is between (i.e. 356 is between A3 and B3), and
return the number below the columns (i.e. C3 (4.05)), and then multiply F1 by
that cell(c3)

again not sure if this can be done, but any assistance would be appreciated.

Thanks,

range calculation help
 

See if this works for you:

=IF(AND(F1=$A$1,F1<=$B$7,F1<""),VLOOKUP(F1,$A$1: $C$7,3)*F1,"Out of Range")

HTH,
Elkar


"Mike Daniels" wrote:

I am not sure if I can do this in excel, but here is what I am trying to do.

If have several value ranges (i.e 0-50, 51-100,
101-500,501-1000,1001-2000,2001-3000,3001-10000). I want to have excel check
a value (1) to determine if it falls between these ranges, and if it does,
return another number defined (2), and multiply the orig. number by the
number provided (i.e 1X2).

Example: A1:0, A2:51 A3:101 A4:501 A5:1001 A6:2001 A7:3001
B1:50 B2:100 B3:500 B4:1000 B5:2000 B6:3000 B7:10000
C1:5.6 C2:4.2 C3:4.05 C4:3.85 C5:3.70 C6:3.50 C7:3.15
F1:356
I want to check what F1 is between (i.e. 356 is between A3 and B3), and
return the number below the columns (i.e. C3 (4.05)), and then multiply F1 by
that cell(c3)

again not sure if this can be done, but any assistance would be appreciated.

Thanks,