Changes to Calculation Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zygy - 16 Oct 2006 08:24 GMT

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 Singapore:-
=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.

Reply to this Message

Bob Phillips - 16 Oct 2006 08:56 GMT

Is it not jus

=H2+E4-D3

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> When I asked the following on the 5th:-
> Is there a way of permanently arranging in col. H that the result of the
[quoted text clipped - 8 lines]
> I have many other worksheets some of which contain many columns of figures
> for which I would like to have a calculation formula.

Reply to this Message

Pete_UK - 16 Oct 2006 13:23 GMT

I think you need something like:

=IF(COUNTBLANK(H2,E3,D3)<>0,"",H2+E3-D3)

i.e. if any of the cells in the COUNTBLANK function are empty, then
return "", otherwise calculate the rest of the formula - perhaps you
can see how you could apply this to other cells.

Hope this helps.

Pete

Reply to this Message