How do I set a max value if a cell exceeds the value. How do I p.

M

Mrtap001

How do I set a max value to a cell. and if the value in that cell exceeds
the value. How do I place the remainder in another cell?
 
F

Frank Kabel

Hi
if your value is stored in A1 use the following two formulas
B1:
=MAX(A1,number)
C1:
=A1-B1
 
Top