View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

... a formula I could use that wouldn't show and
total the Minus figure generated at Column B.


With the headers in A1:N2,
the 1st row of data / formulas will be in row3, in A3:N3
(link to sample file provided below)

Try this:

D3: =IF($B3<0,C3,C3-$B3)
E3: =D3

G3: =IF($B3<0,F3,F3-$B3)
H3: =E3+G3

J3: =IF($B3<0,I3,I3-$B3)
K3: =H3+J3

M3: =IF($B3<0,L3,L3-$B3)
N3: =K3+M3

Select D3:N3 and copy down as many rows as needed

For a neat look, suppress extraneous zeros in the sheet via:
Click Tools Options Uncheck "Zero values" OK

Here's a sample file with the implemented construct:
http://flypicture.com/p.cfm?id=68674

(Right-click on the link: "Download File"
at the top in the page, just above the ads)

File: kevhatch_newusers_1.xls
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----