Nested If Formula not returning correct values

[Damian37]

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.

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

 

[steve the fish]

The start of your formula looks a little odd..

 

[bbott]

Also:

=IF(C7C7, "Mod",IF(D7=" ","Del",IF(D7=C7,"No Change"))))

Unless you actually have a space in D7, this will return FALSE.

 

[steve the fish]

=IF(C6 < D6,"New",IF(D6="","Del",IF(D6 < > C6,"Mod",IF(D6=C6,"No Change"))))

 

[Damian37]

Thank you everyone for your input. I modified my formula using Steve the fish's example and it looks to be working now. Again, thank you all very much!