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.
Create multiple IF function criteria-error
-
- Posts: 8
- Joined: Sun Mar 31, 2019 6:07 pm
Create multiple IF function criteria-error
LibreOffice 6.2 Windows 7 Home
- MrProgrammer
- Moderator
- Posts: 4883
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Create multiple IF function criteria-error
Use something like =PriceCell*HLOOKUP(QuantityCell;{0;10;20;30|1;0.75;0.65;0.55};2;1).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%).
[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).
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).