3 IF's into one

[dache416]

Hello,

I am trying to nest the following 3 IF’s formula into one under “Account” column.

But it is not working.

The cost, gain, and income are reference ranges.

Thank you for your time and consideration.

[FDibbins]

This should work, but in COST, your matching value is Pos, but you are searching for a Neg
=IF(MATCH(D3,Cost,0),"1674",IF(MATCH(D3,Gain,0),"4312",IF(MATCH(D3,Income,0),"4302","")))

[dache416]

Hi FDibbins,
The problem might be related to the figures not maching exactly. The figure in JVU is opposite of what's in SunGard(1674).
The formula yield a #N/A result. I tried using 1 instead of 0 but it's yield a wrong result.
Thanks for helping!

[FDibbins]

Then you need to change the sign in the MATCH
=IF(MATCH(-D3,Cost,0),"1674",IF(MATCH(D3,Gain,0),"4312",IF(MATCH(D3,Income,0),"4302","")))

You may also need to change 1 or both of the other 2