Subtraction Formula with 2 conditions

[teetee1234]

I need to subtract one cell from another cell, based on if there is text in another cell and if the number 1 is found in another cell.

Anyone have a formula to help out?

Thanks!

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[TMS]

As a guess:

Please Login or Register  to view this content.

[teetee1234]

Thank you for your suggestion, that formula returned a value of Conditions not met. Those exact words appeared in my cell. I was hoping for the value of C2-D2.
I will post an example shortly.
Thanks again!

[protonLeah]

Your sample has data in row 3. The solution in post #2 used row 2 so just replace A2 w/A3,... in the formula

[teetee1234]

Hey Ben,
I provided the sample after the post with the formula suggestion, so unfortunately my issue was not just the row, but thanks.
That being said, when I tried the formula in my sample sheet it worked but when I apply to my large database it doesn't. However, I think I am close, so I will keep trying!!
Thanks.

[alansidman]

It is important when you are posting a question here that your sample data while anonymized be representative of your actual data so that you don't end up with a solution that does not work on your actual data. Maybe you should submit a new sample that is representative.

[TMS]

As I explained, it was a guess based on your post.

The revised formula based on your sample:

Please Login or Register  to view this content.

[teetee1234]

So strange that the formula solution provided above works in the sample I created but will not work in my actual database. I have attached the exact row from my database for your eyes and assistance.

[JohnTopley]

Re-enter AB6.

[TMS]

As JT says, re-enter AB6. Either press F2 and Enter. Or re type 1 and press Enter.