"Up to" function?

[Rob]

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?

 

[Fred Smith]

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

d1: =min(c1,b1)

Regards,
Fred.

 

[Rob]

Your a lifesaver! Thank you!

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

d1: =min(c1,b1)

Regards,
Fred.

 

[Fred Smith]

You're welcome. Glad I could help.

Regards,
Fred.