Menu

Previous Topic Next Topic

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

Report

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

Posts: 1292
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: May 7, 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:

Excel formula to subtract one cell from another
Excel formula subtract one cell from another - Best answers
Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it. - Best answers
Excel formula to compare two cells and return a value ✓ - Forum - Excel
Excel formula copy row if cell contains value ✓ - Forum - Excel
Excel formula to compare two cells ✓ - Forum - Excel
Excel formula to find blank cells ✓ - Forum - Programming
Copy data onto sheet only if cell has text ✓ - Forum - Excel

1 reply

Answer 1 / 1

vcoolio

Posts: 1292
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: May 7, 2021

230
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