Page 1 of 1

I am unable to get this formula to work

PostPosted: Fri Apr 12, 2019 6:10 am
by duckie256
=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,"")))))))

Re: I am unable to get this formula to work. Help!

PostPosted: Fri Apr 12, 2019 6:26 am
by robleyd
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.