Formula to subtract one cell value from another.

Question

Report

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

- 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

Reply Ask a question

vcoolio · Accepted Answer · 2019-07-01T19:55:55-0400

Answer 1 / 1

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

1 reply