IFS FUNCTION

Question

Good day I have tried everything under the sun please assist me with what am I doing wrong? When I do not add the ";" the function does not want to carry on it is stuck on the first value. I have even watch the help button video and tried it like that it keeps throwing this error out.

Answer 1

Hi Shantal K,

Thank you for reaching out to the Microsoft Community. My name is Somidotun and I'm happy to help.

Detailed steps to help solve your issue: https://www.ablebits.com/office-addins-blog/excel-formulas-not-working/

Note: This is a non - Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP.

If you still require assistance please come back and ask.

Yours truly, Somidotun

Answer 2

• You have to be consistent. If you use point as decimal separator, you should use commas between the arguments of the function. If you use comma as decimal separator, you should use semicolons between the arguments. You have both semicolons and commas.
• The 1st, 3rd, 5th etc. arguments of IFS should be conditions that evaluate to TRUE or FALSE, and the 2nd, 4th, 6th etc. arguments should be the values to be returned if the condition before it is TRUE. You appear to have groups of 3. That won't work.

If I understand the meaning of X9:Y15 correctly, change the values in Y9:Y15 to 89, 79, 69 etc., and use this formula if you use point as decimal separator

=XLOOKUP(D9, $Y$9:$Y$15, $X$9:$X$15, "", -1)

or if you use comma as decimal separator:

=XLOOKUP(T9; $Y$9:$Y$15; $X$9:$X$15; ""; -1)