help with an "If AND" formula

[Pumpk1n]

I'm running into a challenge with an "if And" formula. What I want to do:
If BV4 = .46, then 0 else
if BV4<.46 and AT4<5 then vlookup BV4 to the Rate table else 9


Can you help me figure out what's the issue? Its returning "False"

=IF(BV4=0.46,0,
IF(AND(BV4<0.46,AT4<5,VLOOKUP(BV4,Grids!$D$70:$E$80,2,false),9)),9)

 

[admiral100]

Hi,

Maybe this : =IF(BV4=0.46,0,IF(AND(BV4<0.46,AT4<5),VLOOKUP(BV4,Grids!$D$70:$E$80,2,FALSE),9))

 

[Pumpk1n]

Hi,

Maybe this : =IF(BV4=0.46,0,IF(AND(BV4<0.46,AT4<5),VLOOKUP(BV4,Grids!$D$70:$E$80,2,FALSE),9))

Thanks!!

 

[admiral100]

You are welcome