View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default "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?