Create multiple IF function criteria-error

Discuss the spreadsheet application
Post Reply
no middle name
Posts: 8
Joined: Sun Mar 31, 2019 6:07 pm

Create multiple IF function criteria-error

Post by no middle name »

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/hgtkfs2tw4gnp ... 1.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
User avatar
MrProgrammer
Moderator
Posts: 4883
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Create multiple IF function criteria-error

Post by MrProgrammer »

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, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply