in excel, i want to show a value over a certain figure

S

snhoj

in excel, i want to show a value over a certain figure and then move/show
that value in another cell. i.e. the amount over say £50 in one cell, shown
in another!
 
J

JLatham

Or if you want to just show the amount in excess of your set limit, then in
the other cell a formula similar to:
=IF(A1>50,A1-50,"")
 
Top