I am unable to get this formula to work
Posted: Fri Apr 12, 2019 6:10 am
=IF(B2="1",25,IF(B2="2",30,IF(B2="3",47,IF(B2="3.5",55,IF(B2="4",63,IF(B2="4.5",71,IF(B2="5",79,"")))))))
Replace the commas with semi-colons and see what happens. Is B2 a string or number? If it is a number, you don't need the quotes ".
You could also use VLOOKUP() which would allow you to easily extend the range of possible values.