Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changes to Calculation Formula
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changes to Calculation Formula
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 Zygy wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Price function difference in Output formula vis a vis Manual Calculation | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Initial Formula Calculation | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |