Combine this if formula

[iRobert]

Hello board members!

I have this formula:

=IF(AND(E18="Yes",OR(A8="ABCD",A8="EFGH")),"-1.48% Fee","")

It need another condition:

=<date(2019,5,1)........"-1.48% fee","")
IF(D16<<date(2019,5,1)........"-1.48% fee","")="" <="" date(2019,5,1)........"-1.48%="">DATE(2019,5,1)........"-1.48% Fee","")
=IF<date(2019,5,1)........"-1.48% fee","")
(D16>DATE(2019,5,1)........"-1.53% Fee","")


How should I nest the date into the first formula?

Thanks

iR</date(2019,5,1)........"-1.48%></date(2019,5,1)........"-1.48%></date(2019,5,1)........"-1.48%>

 

[LMacD]

Re: Please help me combine this if formula

If the first part is false the fee is "" regardless of the date in D16.
If the first part is true the fee can be one of two values depending oin the date in D16

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(AND(E18="Yes",OR(A8="ABCD",A8="EFGH")),IF(D16<DATE(2019,5,2),"-1.48% Fee","-1.53% fee"),"")

[/FONT]

 

[LMacD]

Re: Please help me combine this if formula

Sorry the formula was truncate on post.. not sure why,

 

[iRobert]

Re: Please help me combine this if formula

I can't. I am dense!
I understand the nesting but I cannot write it correctly....


iR

 

[LMacD]

Re: Please help me combine this if formula

That is not the whole formula.

I do not know why I can post the entire string.

 

[iRobert]

Re: Please help me combine this if formula

It happened to me too....It got truncated!!!

iR

 

[iRobert]

Re: Please help me combine this if formula

Try to post it in pieces after (D16

iR

 

[LMacD]

Re: Please help me combine this if formula

Found the problem.
I need to put a space after the "<" take the space out when you ccopy and paste it

=IF(AND(E18="Yes",OR(A8="ABCD",A8="EFGH")),IF(D16< DATE(2019,5,2),"-1.48% Fee","-1.53% fee"),"")

 

[AhoyNC]

Re: Please help me combine this if formula

If you have one of these symbols > or < in your formula put a space around it. The web site thinks its an HTML code and will blank out the rest of your formula.

See you figured it out.

 

[iRobert]

Re: Please help me combine this if formula

Let me try it......
Thanks in advance!

iR