Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel formula halp
Name: sampsas Date: November 14, 2006 at 07:10:08 Pacific OS: Win2000 CPU/Ram: P4 2.8 Product: DELL GX280
Comment:
I have a spreadsheet that I need ot create a formula where the first column will be used to increase the total of second colum, third column will subtract from the second and give an accurate total in the last column.
What I need to have the first cell be able to do is be cleared without changing the second column there for not screwing with the accurate toatl in the last cell. can this be done?
Name: Jennifer SUMN Date: November 14, 2006 at 08:43:35 Pacific
Reply:
You'd need a third column to run your calculation of Column A and B, then another column for the Entry that will be subtracted, and a fourth Column for the result of the calculation.
For Example A contains the number that will be added to column B B contains the number you want to increase C contains the Calculation of the Total of A and B D contains the number to subtract E contains the calculation
Then just use the SUM function to calculate.
Life is more painless for those who are brainless.
0
Response Number 2
Name: Bryco Date: November 14, 2006 at 12:54:29 Pacific
Reply:
Your answer is No. If you change any number it will change the results unless you copy the results and Paste Special, Values into another cell.
Bryan
0
Response Number 3
Name: Jennifer SUMN Date: November 14, 2006 at 15:06:08 Pacific
Reply:
Oops. Bryco is right. I missed that second part. LOL
Life is more painless for those who are brainless.
0
Response Number 4
Name: Grok Lobster Date: November 14, 2006 at 20:39:06 Pacific
Reply:
I think there is probably an =IF formula along with the extra column that Jennifer mentioned that will work.
0
Response Number 5
Name: wizard-fred Date: November 15, 2006 at 00:06:03 Pacific
Reply:
A method that would work is to turn off automatic recalculation. The risk is forgetting to recalculate when you need a new result.
Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...
Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are no...
Summary: Hi, Hate to bother every1, just have a quick question regarding a excel formula. Im using a lot of =sum formulas, i was just wondering in my total figures, is there any chance i can have the display v...
0 
