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. |
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 |