Changes to Calculation Formula
Is it not jus
=H2+E4-D3
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Zygy" wrote in message
...
When I asked the following on the 5th:-
Is there a way of permanently arranging in col. H that the result of the
amount in col. D plus amount in col.E less the amount in col.F is
automatically shown once the entries in cols. D, E & F have been made.
I was given the following formula by Max of Singapo-
=IF(COUNTBLANK(D2:F2)<0,"",SUM(D2:E2)-F2)
My question now is:- how does one change the formula to accommodate other
calculation e.g what is the formula for the following:-H3 = H2 plus E3
minus
D3.
I have many other worksheets some of which contain many columns of figures
for which I would like to have a calculation formula.
|