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

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!

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

=IF(A150,A1,"")
--
Gary''s Student - gsnu200805

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

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(A150,A1-50,"")


"snhoj" wrote:

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!