Need formula in excel sending sum over 25000 to another column

L

legalcarmen

I am trying to install a formula in an excel spreadsheet which allows col m
to get filled if sum of col l is over 25000. Only if the sum in col l passes
25000 then col m is filled because if col l is not over 25000 there should be
no value in col m. Please email me at [email protected]
 
F

Fred Smith

Formulas cannot "send" data to another cell. Formulas always act on the cell
they are in. So in M1, put something like:
=if(sum(L:L)<25000,"",<What you want to appear when over 25000>)

Copy this down column M.

Regards,
Fred
 
Top