Hello,
I am trying to nest the following 3 IF’s formula into one under “Account” column.
HTML Code:HTML Code:But it is not working.HTML Code:
The cost, gain, and income are reference ranges.
Thank you for your time and consideration.
Hello,
I am trying to nest the following 3 IF’s formula into one under “Account” column.
HTML Code:HTML Code:But it is not working.HTML Code:
The cost, gain, and income are reference ranges.
Thank you for your time and consideration.
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","")))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks