Formula to subtract one cell value from another.
Closed
autigers71
-
Updated on Jul 1, 2019 at 07:51 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jul 1, 2019 at 07:55 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 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?
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:
- Excel formula subtract one cell from another
- What is the formula in excel to subtract one cell from another - Best answers
- Excel formula to subtract one cell from another - Best answers
- Number to words in excel formula - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Excel grade formula - Guide
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
- Date formula in excel dd/mm/yyyy - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jul 1, 2019 at 07:55 PM
Jul 1, 2019 at 07:55 PM
Hello Autigers71,
Place the following formula in any cell EXCEPT cell A3:-
I hope that this helps.
Cheerio,
vcoolio.
Place the following formula in any cell EXCEPT cell A3:-
=IF(A3="Closed",A1-A2,"")
I hope that this helps.
Cheerio,
vcoolio.
