Please correct the following formula:
IF(ISNA(VLOOKUP(P31,$P$16:$U$25,6,FALSE)<>0),0,((L31*-1)-U31))))
Problem arising: From the table array P16 to P19, if the results are anything but 0, then the cell has to be zero. But this is does not come correctly as some of my cells with this formula are showing numbers inspite of array being <>0.
Pls help
please attach sample file with desired results
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Attached the problem related worksheet.
I have also changed the formula to solve my problem. The new formula is:
=(IF(ISNA(VLOOKUP(P32,$P$16:$U$25,6,FALSE)),0,IF(VLOOKUP(P32,$P$16:$U$25,6,FALSE)<>0,0,((L32*-1)-U32))))
But im always open to better solutions
i can not understand what you are exactly looking forOriginally Posted by dino4u86
one more thing is the formula "=(IF(ISNA(VLOOKUP(P32,$P$16:$U$25,6,FALSE)),0,IF(VLOOKUP(P32,$P$16:$U$25,6,FALSE)<>0,0,((L32*-1)-U32))))"
is not found in your attached excel sheet
i can not understand what you are exactly looking for
one more thing is the formula "=(IF(ISNA(VLOOKUP(P32,$P$16:$U$25,6,FALSE)),0,IF(VLOOKUP(P32,$P$16:$U$25,6,FALSE)<>0,0,((L32*-1)-U32))))"
is not found in your attached excel sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks