Nested IF formula Nightmare

[Rana Gray]

Hey Everyone,

I have gotten most of my formula to work but I need to add one more condition and I can't seem to figure it out. Here is what I have so far (that I've tested and works): =IF(E16="*Mortgage*",5.25%,IF(F38>5.25%,SUM(F38+2%),5.25%))*OR(IF(E16="*Mortgage*",5.25%,IF(F38>5.25%,SUM(F38+2%),5.25%)))

What I need to add is: If E16="<>*Mortgage*" and/or "<>*Homeowner*" Then use value in cell F38 as is.

As always thank you in advance <3

 

[Rana Gray]

T202303a.xlsm
	D	E	F
16	8.00%	a Homeowner xyz
17
4d

Cell Formulas
Range	Formula
D16	D16	=IF(OR(IFERROR(SEARCH("Mortgage",E16),0),IFERROR(SEARCH("Homeowner",E16),0)),IF(F38>0.0525,F38+0.02,0.0525),"Customer rate")

YOU ARE MY HERO! You're formula is so eloquent - Thank you so so much!!!

 

[Dave Patton]

The formula could be much cleaner if you use a column on your form for the "code"; I used column D.

T202303a.xlsm
	D	E
15	Code	Product Name
16	Mortgage	a Mortgage xyz
17
18	8.00%
19	8.00%
4d

Cell Formulas
Range	Formula
D18	D18	=IF(OR(IFERROR(SEARCH("Mortgage",E16),0),IFERROR(SEARCH("Homeowner",E16),0)),IF(F38>0.0525,F38+0.02,0.0525),"Customer rate")
D19	D19	=IF(OR(D16={"Mortgage","Homeowner"}),IF(F38>0.0525,F38+0.02,0.0525),"Customer rate")

 

[Rana Gray]

The formula could be much cleaner if you use a column on your form for the "code"; I used column D.

T202303a.xlsm
	D	E
15	Code	Product Name
16	Mortgage	a Mortgage xyz
17
18	8.00%
19	8.00%
4d

Cell Formulas
Range	Formula
D18	D18	=IF(OR(IFERROR(SEARCH("Mortgage",E16),0),IFERROR(SEARCH("Homeowner",E16),0)),IF(F38>0.0525,F38+0.02,0.0525),"Customer rate")
D19	D19	=IF(OR(D16={"Mortgage","Homeowner"}),IF(F38>0.0525,F38+0.02,0.0525),"Customer rate")

Thank you I’ll try that