Menu

Formula to subtract one cell value from another.

Report

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

Posts: 1251
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: September 29, 2019

- 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.
Comparing columns and returning value ✓ - Forum - Excel
Which of the following demonstrates the general format of a formula that references a cell in a different worksheet? - Articles
Excel formula to copy a cell from another sheet - How-To - Excel
Excel formula bar not showing cell contents - How-To - Excel
Excel formula to compare two cells and return a value ✓ - Forum - Excel

2 replies

Answer 1 / 2

vcoolio

Posts: 1251
Registration date: Thursday July 24, 2014
Status: Moderator
Last seen: September 29, 2019

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

Reply Ask a question

Recommended

DON'T MISS