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

OpenOffice version 4.1.5, Windows 10 - Pro
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.
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 3195
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 31 guests