Taking a remainder amount from a column and adding it another colu

H

Help for Jason

I am trying to place set a formula so that when you place a number in a
column and it is over a set number the remainder amount goes to another
column.
 
S

SteveG

Assuming the value is in A1 and you want your remainder in B1.

=IF(A1>Your Limit,sum(A1-Your Limit),"")

This returns blank if the number is not greater than your limit.

HTH

Steve
 
Top