Thread: i enter value in one column the next column existing value turn 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default 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

Reply With QuoteReply With Quote