Create multiple IF function criteria-error

Discuss the spreadsheet application

Create multiple IF function criteria-error

Postby no middle name » Sun Apr 14, 2019 3:23 pm

Hello all.

This is the first step attempting to create multiple IF function criteria: 4 different stock quantities (below 10, above 30, between 20 & 30, between 10 & 20) & retail pricing (same, *55%, *65%, *75%).


https://www.dropbox.com/s/hgtkfs2tw4gnpwi/multiple%20IF%20criteria-step1.png?dl=0

I obtain Err 511. I am unable to determine what variable is missing, or how to proceed to the next step.
(see dropbox image link above). Any suggestions…?



Thanks.
LibreOffice 6.2 Windows 7 Home
no middle name
 
Posts: 8
Joined: Sun Mar 31, 2019 6:07 pm

Re: Create multiple IF function criteria-error

Postby MrProgrammer » Sun Apr 14, 2019 3:51 pm

no middle name wrote:This is the first step attempting to create multiple IF function criteria: 4 different stock quantities (below 10, above 30, between 20 & 30, between 10 & 20) & retail pricing (same, *55%, *65%, *75%).
Use something like =PriceCell*HLOOKUP(QuantityCell;{0;10;20;30|1;0.75;0.65;0.55};2;1).
[Tutorial] VLOOKUP questions and answers Q20/A20
If you're not familiar with VLOOKUP/HLOOKUP you'll want to read the material before Q1/A1.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3813
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests