Formula to subtract one cell value from another.

Closed
autigers71 - Updated on Jul 1, 2019 at 07:51 PM
vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - 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:

1 response

vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
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