Menu

Formula to subtract one cell value from another. [Closed]

Report

autigers71 - Updated on Jul 1, 2019 at 07:51 PM
vcoolio

Posts: 1270
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: January 20, 2021

- Jul 1, 2019 at 07:55 PM

Hello,

I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?

System Configuration: Windows / Chrome 75.0.3770.80

Related:

Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it.
Suppose cell c5 contains the formula =b$6+c1 - Best answers
Formula to subtract one cell from another in excel - Best answers
Comparing columns and returning value ✓ - Forum - Excel
Suppose cell c5 contains the formula =b$6+c1 ✓ - Forum - Office Software
Only Countif value in cell A matches cell B ? - Forum - Office Software
How to copy cells from one sheet to another in excel using formula - How-To - Excel
Excel formula to duplicate rows based on cell value ✓ - Forum - Excel

1 reply

Answer 1 / 1

vcoolio

Posts: 1270
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: January 20, 2021

215
Jul 1, 2019 at 07:55 PM

Hello Autigers71,

Place the following formula in any cell EXCEPT cell A3:-

=IF(A3="Closed",A1-A2,"")

I hope that this helps.

Cheerio,
vcoolio.

Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Recommended

DON'T MISS