Prev: Grouping and sorting details
Next: Worksheet Function required
From: Bonnie on 12 May 2010 06:40
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
From: ozgrid.com on 12 May 2010 06:43
=IF(A1<>"",0,"")


--
Regards
Dave Hawley
www.ozgrid.com
"Bonnie" <Bonnie(a)discussions.microsoft.com> wrote in message
news:1F5A64A0-224E-4C75-84A9-BC7DCABD52F7(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Grouping and sorting details
Next: Worksheet Function required