"up to" in Excel is "min", as in:

d1: =min(c1,b1)

Regards,
Fred.

"Rob" wrote in message
...
I need to enter a number into a cell that is related to the amount in
another
cell. For instance...

A1 = 100
B1 = 200
C1 = 300
D1 = C1, but only "up to" the amont in B1. Therefore, D1 will be 200.

Can someone help me with this "up to" formula?