I am unable to get this formula to work

Discuss the spreadsheet application
Post Reply
duckie256
Posts: 1
Joined: Fri Apr 12, 2019 6:08 am

I am unable to get this formula to work

Post 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,"")))))))
OpenOffice version 4.1.5, Windows 10 - Pro
User avatar
robleyd
Moderator
Posts: 5036
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Post 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.
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
Post Reply