Write cell workbook is not working while using formula

Help Activities
, ,
1

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

image

2

I think it should be separated by semicolon

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

Hope this helps :slight_smile:

3

Hi @Sathish_Kumar5

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

Regards

4

Hi @Sathish_Kumar5 ,

Could you please share the snap of write range activity.?

Thanks,
Gautham.

5

yeah sure please find the sample excel without main data
Filteredcombo.xlsx (9.0 KB)

i want the result in s column

6

please find the excel file itself
Filteredcombo.xlsx (9.0 KB)

7

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

8

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

9

Hey @Sathish_Kumar5

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

Thanks,
Gautham.

10

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.

1 Like
11

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.

12

Very huge thanks for your efforts and yeah it worked

1 Like
13

My pleasure @Sathish_Kumar5

1 Like
14

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

15

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

1 Like
16

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

17

No Problem, Always happy to help.

1 Like
19

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