Formula with autopopulate.

**sput_sput** · 07-23-2009, 12:30 PM

In the spread sheet when column E is updated it automatically updates in column G, but the formula i have used does not recognise 0

Also when i pre-populate the formula in column H, it automatcially reverts to
-1, but this then affects the total. I need a formula that if column G is blank it shows a zero in column H

**contaminated** · 07-23-2009, 12:39 PM

Change your formula to

Please Login or Register  to view this content.

**sput_sput** · 07-23-2009, 01:21 PM

Thats great, but i will need to pre populate column H and when i do this, it reverts to -1, i would need it to be 0. Any ideas?

**sput_sput** · 07-23-2009, 01:26 PM

this is what i mean

**sput_sput** · 07-23-2009, 01:57 PM

Also noticed when you put 0 in column E it doesnt work on column G

**gmcconnell** · 07-24-2009, 02:28 PM

I want to help but I'm not really sure what I'm looking at when I open your spreadsheet. If you could put some descriptions or something in it would make it much easier for you to get your anticipated solution.