i used this excel formula =“=IFS(I2=1,G2/1,I2=2,G2/2,I2=3,G2/3)” in write cell then after writing it im not getting the result instead im getting like mentioned in pic

I think it should be separated by semicolon

```
"=IFS(I2=1;G2/1;I2=2;G2/2;I2=3;G2/3)"
```

Hope this helps

If possible can you share the excel file, if it doesn’t has confidential data.

Regards

yeah sure please find the sample excel without main data

Filteredcombo.xlsx (9.0 KB)

i want the result in s column

please find the excel file itself

Filteredcombo.xlsx (9.0 KB)

this is the formula im using =IFS(I2=1,G2/1,I2=2,G2/2,I2=3,G2/3)

this is the formula im using =IFS(I2=1,G2/1,I2=2,G2/2,I2=3,G2/3) please let me know if u need anything else

Hey @Sathish_Kumar5

Please share a snap of the activity in studio in such a way the properties pane is also visible.

Thanks,

Gautham.

Hey @Sathish_Kumar5 ,

Please attached the file where I have given the formula for you, I am using excel Version Office 16 and I couldn’t find the ‘IFS’ in the drop down so went with a slightly different approach.

Filteredcombo.xlsx (9.1 KB)

To Implement the same in the Workbook range activity, Please use

“=IF(I2=1,G2/1,IF(I2=2,G2/2,IF(I2=3,G2/3,”““Value in I Column is not in range 1-3"””)))"

I also found the official Microsoft page on ‘IFS’ where they have listed the Excel versions which support the function, Please check if the Excel version you are using is one of them that may be the reason the function is not working as expected too.

Happy Automating.!

If this response has helped you, please mark it as a solution.

Thanks,

Gautham.

The problem may be due to incorrect use of the IFS function or incorrect formatting of the formula. Make sure that the conditions in the IFS function match your requirements correctly. Check the correct spelling of the cells. You may have provided incorrect cell references or incorrect column and row addresses. Verify that cells I2 and G2 contain the expected values. The problem may be with the data you are trying to process.

Very huge thanks for your efforts and yeah it worked

My pleasure @Sathish_Kumar5

Actually i used this formula to write just added double quote ok “=IF(I2=1,G2/1,IF(I2=2,G2/2,IF(I2=3,G2/3,”“Value in I Column is not in range 1-3"”)))".

so in this im facing only one issue like im not getting zero so is there anything i can do to get zero values

Hi @Sathish_Kumar5 ,

I am having difficulty understanding your comment.

When exactly do you want 0 as result.?

Can you give a sample case .?

Thanks,

Gautham

Hi actually its my fault it is working fine i didnt extend the code till end so it is working fine… anyway thanks for quick response

No Problem, Always happy to help.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.