Ask Your Question
0

LibreCalc Nested if question

asked 2019-08-22 20:22:06 +0200

krisium gravatar image

Hello there, I can problems to figure out how to write nested if function correctly. Tried many variations and still no result.

I need to create a formula like this: If sales are more then 12000 EUR, write 900 If sales are more then 16000 EUR, write 1100 If sales are more then 20000 EUR, write 1300 If sales are more then 24000 EUR, write 1400

Tried all variations and cannot work it out.

Please help

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-08-22 23:27:53 +0200

Opaque gravatar image

updated 2019-08-23 13:16:56 +0200

Hello

to avoid nesting you may use (assuming value in cell A1)

=IFS(A1>24000,1400,A1>20000,1300,A1>12000,900,A1<1200,0)

Note: The first condition met will evaluate, thus the order of the conditions and their respective values is important.

Update - thanks to @Mike Kaganski, noticed that I've left a "0" and it should read:

=IFS(A1>24000,1400,A1>20000,1300,A1>12000,900,A1<=12000,0)

edit flag offensive delete link more

Comments

:-) which leaves values from 1200 to 12000 inclusive undecided ;-D

For "default" case (like "what to do in all other cases"), just use 1 or TRUE() as the condition for the last value.

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-23 07:31:12 +0200 )edit

Thank you so much for your help! Got a solution

krisium gravatar imagekrisium ( 2019-08-24 11:33:27 +0200 )edit
0

answered 2019-08-22 21:19:45 +0200

gregors15 gravatar image

Hi , Assuming your value is in A6, Try =IF(A6>24000,1400,IF(A6>20000,1300,IF(A6>16000,1100,IF(A6>12000,900,0))))

Let us know if it helps.

edit flag offensive delete link more

Comments

Thank you very much. It works!

krisium gravatar imagekrisium ( 2019-08-24 11:32:30 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-22 20:22:06 +0200

Seen: 44 times

Last updated: Aug 23