Need to write excel formula

Help Activities
, , ,
1

How do i write in a cell below excel formula
From G2 cell i need write.
“=IF(C2>20000000,“Hight”,“Low”)”

2

HI @Pujari_Manjunatha

You can try with this syntax

=IF(B9>15,"HIGH","Low")

image

Try with this syntax in the Write cell activity

"=IF(B9>15,'HIGH','Low')"

Regards
Gokul

3

I need to write in write cell activity

image
image988×323 14.3 KB

1 Like
4

Try with this one @Pujari_Manjunatha

5

Hello @Pujari_Manjunatha
Try this

"=IF(B8>15,""HIGH"",""Low"")"

image

6

Formula working fine, Then i have write for all the rows, how to do?

image
image1150×991 39.5 KB

7

You have to generate the Cell reference(“B1”, “B2”, etc) and formula reference dynamically using foreach loop for the entire table

8

For each or for each row?

9

Please feel free to try both. But in this case for each row is a better fit

10

Hi @Pujari_Manjunatha ,

Is it possible for you to use Modern Excel Activities, If so, You could check the below implementation :
image

We first use Write Cell Activity with the Formula you would want to write for the First Row Cell (B2). Then we perform Auto Fill range using the Auto Fill Activity. This will apply the formula to all the rows available.

Before :
image

After :
image

Let us know if this doesn’t work or if you are facing any difficulties.

11

Hello @Pujari_Manjunatha
Use Excel auto fill range activity,

  1. Use write cell and enter the formula, like in G2
"=IF(B8>15,""HIGH"",""Low"")"
  1. Use auto fill range activity, where pass the Source as G2 and destination as G2:G10 or your specific destination. The sheet name can change in Properties

image

12

Even though I can enter the formula in each cell, it always outputs the same result.
image

image
image910×414 18.8 KB

13

@Pujari_Manjunatha
It Happens because, all rows compare with C2. We need to increment the the C range also

Try this

"=IF(C"+(index+2).tostring+",""High"",""Low"")"
1 Like
14

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