Can anyone tell me why the following function doesnt work
=IF(B10=10,“250000”,IF(“10”=B10,“220000”, IF(“20”=B10, “185000”, IF(“25”=B10,“160000”, IF(“30”=B10,“140000”, IF(“35”=B10,“120000”, IF(“40”=B10,“105000”, IF(“45”=B10,“95000”, IF(“50”=B10,“80000”, IF(“55”=B10,“65000”, IF(“60”=B10,“60000”, IF(“65”=B10,“55000”, IF(“70”=B10,“45000”;IF(“75”=B10,“40000”, IF(“80”=B10,“35000”, IF(“85”=B10,“30000”,IF(“90”=B10,“25000”, IF(“95”=B10,“21000”, IF(“100”=B10,“20000”,0)))))))))))))))))))
Thanks
Check the 2nd B10=“10”. Maybe it is supposed to be 15?
Also, the quotes around the tested values is telling LO to look at it as a text value. IF it is not a text value of whatever, then go on. Remove the quotes from the tested values. That is, B10=20 and not B10=“20”.
As a test, enter '10 or '20 (that’s an apostrophe) to see how the text value affects your test result.
Beside the excellent answer from @Rugslug, I recommend in case of a longer if-formula to always draw a decision tree, this helps to find mistakes a @Rugslug pointed out.