Hi,
I am working on a file (attached sample file) that has a calculated field using nested IF. The formula is written to satisfy multiple criteria to calculate the file.
In a part of the formula that is mentioned above, I want to return C2 if AND(D2<C2,G2<>0,I2<>0,B2="Group B") are TRUE. If only B2="Group B" is FALSE, I want to return D2. But the issue I have here is that I want to add other criteria in this formula so that it checks for every criteria and returns the value accordingly. I am a little confused on how to approach this. If anybody can suggest a different approach to deal with this situation, it will be greatly appreciated.
If the above explanation is not clear, in the attached file, I've highlighted the Criteria under "List of Criteria", that I've tried explaining above. The formula in column L is written based on all the criteria listed in the file.
If further explanation is needed, please feel free to ask any questions.
Thanks
VJ
Bookmarks