I am unable to get this formula to work
I am unable to get this formula to work
=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,"")))))))
OpenOffice version 4.1.5, Windows 10 - Pro
Re: I am unable to get this formula to work. Help!
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.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers