### 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,"")))))))

User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

https://forum.openoffice.org/en/forum/

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=97693

Page **1** of **1**

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,"")))))))

Posted: **Fri Apr 12, 2019 6:26 am**

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.

You could also use VLOOKUP() which would allow you to easily extend the range of possible values.