Re: [libreoffice-users] switch function in calc

=On 6 Apr 2026 at 18:46, James wrote:


Date sent:60;Mon, 6 Apr 2026 18:46:39 -0400</span>
Subject:;Re: [libreoffice-users] switch function in 
calc
To:0;users@global.libreoffice.org
From:&#160;James &lt;bjlockie@lockie.ca>


> Nice.
> I googled it and found switch but ifs is the best solution.
> Thanks everyone.
>
> On 2026-04-06 04:37, Regina Henschel wrote:
> > Hi James,
> >
> > James schrieb am 06.04.2026 um 06:15:
> > > A1 contains the number 14023.
> > > B1 contains the formula =SWITCH(AND(A1>5000,A1<15000),20%,A1>15000,30%)
> > > B1 is showing 30% when I expected 20%.> >> What am I doing wrong?
> >
> > SWITCH is the wrong function. Use IFS instead.
> > =IFS(AND(A1>5000,A1<15000),20%,A1>15000,30%)
> >
> > Kind regards,
> > Regina


Not clear on what you actually are trying to do??
Results from the formula have 3 options #N/A , 20% or 30%
Might be that value of A1 only falls into ranges that return 20% or 
30%, but is an issue if it could be exactly 15000?




1500
#N/A</div>\u201c=IFS(AND(A3>5000,A3<15000),20%,A3>15000,30%)
\u201c<1500
15000
#N/A</div>\u201c=IFS(AND(A4>5000,A4<15000),20%,A4>15000,30%)
\u201c=15000
15001
0.3\u201c=IFS(AND(A5>5000,A5<15000),20%,A5>15000,30%)
\u201c>15000</span>
14999
0.2\u201c=IFS(AND(A6>5000,A6<15000),20%,A6>15000,30%)
Between 1501 and 14999




> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/> Privacy Policy: 
> https://www.documentfoundation.org/privacy




+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)60;
mailto:mikes@guam.net&#160;
mailto:msetzerii@gmail.com
mailto:msetzerii@gmx.com
Guam - Where America's Day Begins&#160;
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy