Formula to subtract one cell value from another.

Closed

Excel

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

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

Excel formula to subtract one cell from another
Excel how to subtract one cell from another - Best answers
Excel subtract one cell from another - Best answers
Position formula in excel ✓ - Office Software Forum
How to copy data from one excel sheet to another - Guide
Copying data from one Excel sheet to another. ✓ - Excel Forum
1st, 2nd, 3rd position formula in excel - Excel Forum
Formula to calculate vat in excel - Guide

1 response

Answer 1 / 1

vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 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.

Similar discussions

If a cell contains any text then add a value

If cell = date return yes or no.

Copying data from one Excel sheet to another.

Excel if range of cell contain a text put a cell value in

Counting number of times a value appears if..

How to copy a data from one sheet to another, when specific criteria is met

Similar discussions

Subscribe To Our Newsletter!