If function not working (based on x, y, z number)

[marshen]

Hi all.

I have the formula below

=IF(E11="7.5",L6*K11,IF(E11="5.0",M6*K11,IF(E11="3.5",N6*K11)))

In cell E11 i have the following in a drop down list, "7.5" "5.0" "3.5"

I keep getting FALSE as my answer, if anyone could guide me in the right direction that's be appreciated.

Mark

 

[t0azt]

Are the numbers in E11 actually in quotes? If not you just need to remove the quotes from the formula.

 

[marshen]

yes they are just for the purpose of the formula. I only did it like this as previously I did it this way when I wanted a specific word to appear when using the IF formula.

Thanks

Mark