If formula with multiple outcomes

[Ambry1975]

Hi All

Apologies for this, but I don't seem the be able to find the answer but feel that it should be fairly obvious.

I need a formula that will calculate an If function but look at 2 different cells and subtract the amount in the cell that has a value (worksheet attached), either of the yellow boxes may have data in but could also be blank - I have managed to get it to work with one cell but not both with - =IF(ISBLANK(C2),A2,A2-C2). I essentially need the formula to subtract the amount that is in the yellow boxes.

Advise on if this is possible would be much appreciated

Thanks

[TMS]

Not sure why you need to test C2, or D2, for blank. Try just:

Please Login or Register  to view this content.

[6StringJazzer]

There are several combinations of blank/not blank that could happen here and it's not clear what you want in each case. Can both yellow cells have values? I took at stab at it:

Please Login or Register  to view this content.

• If C2 is not blank the result will be A2-C2. (D2 will be ignored, doesn't matter if it's blank or not)
• If C2 is blank, and D2 is not blank, the result will be A2-D2
• If both C2 and D2 are blank, the result will be A2

[6StringJazzer]

Not sure why you need to test C2, or D2, for blank.

I was overthinking this, good answer.

[Ambry1975]

Thanks both, yes I think that I was over thinking it as well - just couldn't see what I needed to do

Both worked and I can use both for other projects too

Much appreciated

[TMS]

You're welcome. Thanks for the rep.

[TMS]

Here's a catch all that should cope with pretty much anything:

Please Login or Register  to view this content.

Put whatever rubbish you like into that and see what happens

[Ambry1975]

This is great

Thanks for the update

[TMS]

Again, you're welcome.