If function issue:

[FGaxha]

Need to remove false:
=if(E3=“TIAA”,if(and(d3>=4.5),d3<=5.25),if(n3=“12/1/2018”,D3/100,D3*F3/100)),0)

 

[awoohaw]

you have an extra close paren in the and statement (after the 4.5).
this is an updated formula: =IF(E3="TIAA",IF(AND(D3>=4.5,D3<=5.25),IF(N3="12/1/2018",D3/100,D3*F3/100)))
I think you will get a false if the value in D3 is outside of your range.
This may take that FALSE out and replaces it with a 0.
=IF(E3="TIAA",IF(AND(D3>=4.5,D3<=5.25),IF(N3="12/1/2018",D3/100,D3*F3/100),0),0)

 

[FGaxha]

Thank you,
I haven’t tried yet but your function looks completely.
I appreciate it.

 

[FGaxha]

Sir,
It removes the False, but:
For some reason this function is to counting the date 12/1/2018. It is taking all datas 2017 and 2016.
Pleade help
=IF(E3="TIAA",IF(AND(D3>=4.5,D3<=5.25),IF(N3="12/1/2018",D3/100,D3*F3/100),0),0)

 

[awoohaw]

Well, you have a text value for date, I'm not sure why you had that. I used a text version of your date.
You didn't post a copy of your spreadsheet (see the xl2bb tool that is available here).

Here is something I would do. Fill in your limits in the section above. And then calculate based on those variables. I use a LET function, but that is probably not needed.

Some Mr Excel Questions.xlsx
	A	B	C	D	E
8		Target Company	TIAA
9		Min Rate	4.5
10		Max Rate	5.25
11		Target Date	2/12/2018
12
13
14	Company	Rate	Date	Multiplier	Calculation
15	TIAA	5	2/12/2018	2	0.05
Sheet5

Cell Formulas
Range	Formula
E15	E15	=LET( c,$C$8,minr,$C$9,maxr,$C$10,tdt,$C$11, IF(A15=c,IF(AND(B15>=minr,B15<=maxr),IF(C15=tdt,B15/100,B15*D15/100),0),0) )

 

[FGaxha]

It works great.
Thanks again

 

[awoohaw]

You're welcome. If not already done, please mark the thread solved/answered.