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