"jv" wrote:
I need a formula that would subtract 200,000 from a cell and if the result is
a minus, zero would be put in the cell.

One way ..

Try in say, B2: =MAX(A2-200000,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---