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 420m2(Build:9821) - 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: 3039
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 35 guests