I am unable to get this formula to work

Discuss the spreadsheet application

I am unable to get this formula to work

Postby duckie256 » 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,"")))))))
OpenOffice version 4.1.5, Windows 10 - Pro
duckie256
 
Posts: 1
Joined: Fri Apr 12, 2019 6:08 am

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

Postby robleyd » 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.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2932
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: Zizi64 and 41 guests