Hello all,
I'm trying to write a nested if statement in order to show accounts that have been added, deleted, modified, or no change. Currently the formula is showing modified for accounts that have been deleted. When I look at the formula, I can see the returned value is correct, because the account has been modified, but I would like to differentiate accounts where all access has been removed versus accounts where the access has been restricted, but not completely removed. The formula I am using is:
=IF(C7<D7,"New",IF(D7<>C7, "Mod",IF(D7=" ","Del",IF(D7=C7,"No Change"))))
As you can see by my sample output, the Bold and Italics Mod results should be Del instead of Mod. Am I not returning the proper values, because of the order in which I have the nested if statements? Thanks for taking the time to look at this.
I'm trying to write a nested if statement in order to show accounts that have been added, deleted, modified, or no change. Currently the formula is showing modified for accounts that have been deleted. When I look at the formula, I can see the returned value is correct, because the account has been modified, but I would like to differentiate accounts where all access has been removed versus accounts where the access has been restricted, but not completely removed. The formula I am using is:
=IF(C7<D7,"New",IF(D7<>C7, "Mod",IF(D7=" ","Del",IF(D7=C7,"No Change"))))
As you can see by my sample output, the Bold and Italics Mod results should be Del instead of Mod. Am I not returning the proper values, because of the order in which I have the nested if statements? Thanks for taking the time to look at this.
Count of GROUP_NAME | REPORT_DATE | ||||||
NTID_LOGIN | FULL_NAME | Jan-15 | May-15 | Grand Total | Profile Change | New Additions | |
LOGIN1 | NAME1 LASTNAME1 | 2 | 2 | FALSE | New | ||
LOGIN2 | NAME2 LASTNAME2 | 1 | 1 | FALSE | Del | ||
LOGIN3 | NAME3 LASTNAME3 | 1 | 1 | 2 | TRUE | No Change | |
LOGIN4 | NAME4 LASTNAME4 | 3 | 3 | FALSE | Mod | ||
LOGIN5 | NAME5 LASTNAME5 | 1 | 1 | 2 | TRUE | No Change | |
LOGIN6 | NAME6 LASTNAME6 | 2 | 2 | FALSE | Del | ||
LOGIN7 | NAME7 LASTNAME7 | 1 | 1 | FALSE | New | ||
LOGIN8 | NAME8 LASTNAME8 | 1 | 1 | FALSE | Mod | ||
LOGIN9 | NAME9 LASTNAME9 | 1 | 1 | FALSE | Mod | ||
LOGIN10 | NAME10 LASTNAME10 | 3 | 1 | 4 | FALSE | Mod |
Last edited by a moderator: