i enter value in one column the next column existing value turn 0
 

I am working same work sheet with two columns one is Anticipated Variation
cost and the other approved variation with corresponding total. when i enter
cost in approved variation the corresponding row in anticipated variation
column should auotmaticlly become zero.cna you help me out with the formula
to use

i enter value in one column the next column existing value turn 0
 

=IF(A1<"",0,"")


--
Regards
Dave Hawley
www.ozgrid.com
"Bonnie" wrote in message
...
I am working same work sheet with two columns one is Anticipated Variation
cost and the other approved variation with corresponding total. when i
enter
cost in approved variation the corresponding row in anticipated variation
column should auotmaticlly become zero.cna you help me out with the
formula
to use