Formula to subtract one cell value from another.

Report
-
vcoolio
Posts
1251
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 29, 2019
-
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

2 replies

Posts
1251
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 29, 2019
207
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

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 5793 users have said thank you to us this month