| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have B column turn red on conditional formatting of E column: | Excel Worksheet Functions | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
| making a new column based on data in an existing column | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Hybrid Mode
