"Up to" function?
 

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?

"Up to" function?
 

"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?

"Up to" function?
 

Your a lifesaver! Thank you!

"Fred Smith" wrote:

"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?

"Up to" function?
 

You're welcome. Glad I could help.

Regards,
Fred.

"Rob" wrote in message
...
Your a lifesaver! Thank you!

"Fred Smith" wrote:

"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?