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

Report
-
Posts
1270
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 20, 2021
-
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 reply

Posts
1270
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 20, 2021
215
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!