by Anonymous on November 12th, 2009

Question

Help answer this question below.

For the life of me i can't remember the formula to add and subtract in a balance sheet type in excel. What is the formula for cell B being plus, cell C being minus and cell D being the balance?

Like
Report

Share:: Facebook; Twitter; Other

Answers. 2 helpful answers below.

by spock's brain on November 12th, 2009
in B type "="then click on the B cell type "-", click on C cell then enter.

You can type the resulting formula yourself as well but this is so easy I never bother so don't remeber it either!
Comments
Add a comment...
- Like
- Report
No comments. Post one | Permalink
by Brian I on November 12th, 2009
Assuming that cell B6 is to be added and C6 is to be subtracted, and also assuming that the value in cell C6 is a positive value, the formula in cell D6 would be =B6-C6.

If the value in C6 is a negative value it would be =B6+C6.
Comments
Add a comment...
- Like
- Report
No comments. Post one | Permalink

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

I need a formula in Excel that does the following.. If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011 | 2 people like this
In Microsoft Excel I need 25 hours to be displayed but when I enter 25:15 (hours:minute) it shows 1:15. Any ideas on how to fix this?
by One mans opinion on August 10th, 2011 | 1 person likes this
How do I identify duplicate rows in Excel 2003? (In plain english please.)
by Yeahwell... on September 16th, 2011 | 1 person likes this
Could someone give me a good definition of VLOOKUP in Excel?
by slimNanny on August 13th, 2011 | 1 person likes this
What are examples of Spreadsheet application software?
by tinmanEvil on August 13th, 2011 | 1 person likes this
More Microsoft Excel See only professionally researched Microsoft Excel questions

You're reading For the life of me i can't remember the formula to add and subtract in a balance sheet type in excel. What is the formula for cell B being plus, cell C being minus and cell D being the balance?

Follow us on Facebook!

Related Ads

Professionally Researched

About Us

About Answerbag

Sitemap

Professionally Researched Questions

Legal

Privacy Policy

Terms of Use

Disclaimer

Ad Choices
Follow Us on Facebook

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Latest Tweet

What is a movie that was ignored you thought great? http://t.co/FsBFmVd7

Follow Answerbag on Twitter!

Answerbag

Question

For the life of me i can't remember the formula to add and subtract in a balance sheet type in excel. What is the formula for cell B being plus, cell C being minus and cell D being the balance?

Answers. 2 helpful answers below.

Comments

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Hello, I need some help creating a formula in excel. Can someone help with this formula? =IF(C5>40,((C5-40)D51.5)+40D5,IF(C5<=40,C5D5,0))..C5=hours worked D5=hourly pay..If cell b5 contains a value then only 40 or less hours can be calculated. Help!

If cell A1 reflects X1234567. What formula can I enter into cell B1 that will reflect the first character in cell A1, which in this case is X, then enter another formula in cell C1 that will reflect the second character in cell B1, which is 1, and so on.

Cell A1 reflects X1234567. What formula can I enter into cell B1 that will reflect the first character from cell A1, which in this case is X, then enter another formula in cell C1 that will reflect the second character from cell A1, which is 1, and so on?

Excel question: Can a single cell have more than one "if" formula? For instance, if cell D7 is 32, then cell K7=1; if D7 is 38, then K7=2; if D7 is 42, then K7=3; if D7 is 45, then K7=4.

In msexcell what is the formula for comparing the data in col A with data in col.B and give the result in col.c i.e the data in cell A1 has to search for the data in col B from cell 1,2,3,...n, like wise cell A2 has to search data in col.B from Cell 1..n

Professionally Researched

How do I add two email hyperlinks to one cell in Excel?

How do I add text in an Excel spreadsheet cell?

Can a Pantech C610 cell phone be used by any cell phone provider?

Can cell phones be used as ps3 mics?

Where are cell membranes found?

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Question

For the life of me i can't remember the formula to add and subtract in a balance sheet type in excel. What is the formula for cell B being plus, cell C being minus and cell D being the balance?

Answers. 2 helpful answers below.

Comments

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

Answerbag.com Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!