## Create multiple IF function criteria-error

### Create multiple IF function criteria-error

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

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.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).

MrProgrammer
Moderator

Posts: 3955
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA