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

[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!

 

[Gary''s Student]

=IF(A1>50,A1,"")

 

[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,"")