Re: add another IF to an IF, AND, OR statement
Do you want it to be checked after or before ISBLANK(A142)? If so do you want it to be checked before or after I142 is checked for subscriber?
If before ISBLANK(A142)
=IF(I142="Trial","Trial",IF(ISBLANK(A142),,IF(AND(L142-TODAY()>1,OR(I142="Subscriber RENEWAL",I142="Subscriber NEW")),"",$J$5&I142)))
If before checking
I142 [COLOR=#000000][FONT=Inconsolata]=IF(ISBLANK([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]A142[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]),,IF(I142="Trial","Trial",[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]IF(AND([/FONT][/COLOR][COLOR=#7E3794][FONT=Inconsolata]L142[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-TODAY()>[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]1[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],OR([/FONT][/COLOR][COLOR=#11A9CC][FONT=Inconsolata]I142[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"Subscriber RENEWAL"[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#11A9CC][FONT=Inconsolata]I142[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"Subscriber NEW"[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])),[/FONT][/COLOR][COLOR=green][FONT=Inconsolata]""[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#A61D4C][FONT=Inconsolata]$J$5[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]&[/FONT][/COLOR][COLOR=#11A9CC][FONT=Inconsolata]I142[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])))
[/FONT][/COLOR]If after I142
=IF(ISBLANK(A142),,IF(AND(L142-TODAY()>1,OR(I142="Subscriber RENEWAL",I142="Subscriber NEW")),IF(I142="Trial","Trial",$J$5&I142))
Hope this helps.