Feb 16 2022 05:45 AM
I am trying to include a IFS Function on my Sheet but it only shows #NAME? I tried changing the ; to , but that didn't work too. I included a screenshot
Feb 16 2022 06:01 AM
=IFS(D8<$H$23,10,D8<$G$18,2,D8<$D$18,0)
If i remove the " " around the numbers 10, 2 and 0 it works in my file.
Feb 16 2022 06:25 AM
@OliverScheurich Doesn't work , this is the result
Feb 16 2022 07:20 AM
@PapaJiOfficial
That could be wrong quotes, from screenshot that's not clear. Please try to open attached file and compare.
Feb 16 2022 07:31 AM
Feb 16 2022 08:02 AM
@Sergei Baklan Here are the screenshots, still not working
Feb 16 2022 11:53 AM
@PapaJiOfficial
Maybe you shall use semicolons instead of commas. Perhaps you may share sample file?
Feb 17 2022 01:07 AM
Feb 17 2022 03:46 AM
Feb 17 2022 03:56 AM
That doesn't matter how the value appeared in the cell, manually entered, by formula or that's linked value. All shall work. The only be sure be sure the linked value is number, not text, otherwise you shall work with it as with text.
Feb 17 2022 05:50 AM
Feb 17 2022 06:32 AM
Feb 17 2022 06:37 AM
@PapaJiOfficial If you go to Formulas - Show Formulas and also Trace Dependents do you see anything that could be causing a conflict in these cells? Are any of them having unexpected formatting (General instead of Number?)
Feb 17 2022 08:17 AM
@allysharp @Sergei Baklan The formulas look ok but when I input the IFS Function, it only shows wrong solutions. As seen in the screenshots in this message
Feb 17 2022 11:06 AM
1) if possible never copy/paste formula from web or text, especially if you are not in US locale. Preferably open other file with correct formula, doesn't matter in which locale it was created - Excel automatically converts formula to your locale.
If you have no Excel file and not sure, check with this tool how formula shall be written in your locale Translator • Excel-Translator
2) I think formula shows correct result, just not one you expect. Most probably data is wrong. My guess your data is texts, not numbers. Other words "$500", not number 500 formatted as currency.
Perhaps something else, but without sample file that could be a very long discussion.