Write formula excel

[oshan (Oviya S)]

hi friends

I want to type the below formula into excel cell for the whole column.
=IF(AND(K2>J2,K2>I2),“Enter comment”,“”)

i want to pass the cell Number dynamically as below. but getting error.
can you help me .

“=IF(AND(K”+RowIndex.toString+“>J”+RowIndex.toString+“,K”+RowIndex.toString+“>I”+RowIndex.toString"),“+”“Enter comment”+“,”“)”.ToString

[PlutoPeaM (Bhudis Wittayanusit)]

Hello @oshan

Try this mate
“=IF(AND(K” + RowIndex.toString+“>J”+RowIndex.toString+“,K”+RowIndex.toString+“>I”+RowIndex.toString + “),”+“”“Enter comment”“” + “,” + “”“”“” + “)”

you are missing one (+) sign after RowIndex.toString

[oshan (Oviya S)]

OMG…silly mistake … thanks a lot…

[PlutoPeaM (Bhudis Wittayanusit)]

No problem mate @oshan ,

I have some trick if you want to apply this formula to every row in your datatable you don’t need to put RowIndex.tostring
your formula will look like this (if you start from second row)

“=IF(AND(K2>J2,K2>I2),”+“”“Enter comment”“” + “,” + “”“”“” + “)”

then you assign in range you want such as “AF2:AF100”, excel will automatically generate next row for you.

hope this help !!!

[oshan (Oviya S)]

@PlutoPeaM

“=IF(AND(K2>J2,K2>I2),”+“”“Enter comment”“” + “,” + “”“”“” + “)”

@PlutoPeaM thanks , but it has to change the cell no also.
“=IF(AND(K2>J2,K2>I2),”+“”“Enter comment”“” + “,” + “”“”“” + “)”
when its 3rd row, it should be
“=IF(AND(K3>J3,K3>I3),”+“”“Enter comment”“” + “,” + “”“”“” + “)”

[PlutoPeaM (Bhudis Wittayanusit)]

Yes, when it 3rd row excel will automatically put 3 instead of 2 but you need to define your range such as “AF2:AF10” it will put this formula start from AF2 and end at AF10 and your formula will update number of row automatically

[oshan (Oviya S)]

@oshan

“=IF(AND(K” + RowIndex.toString+“>J”+RowIndex.toString+“,K”+RowIndex.toString+“>I”+RowIndex.toString + “),”+“”“Enter comment”“” + “,” + “”“”“” + “)” you are missing one (+) sign after RowIndex.toString

Thanks @PlutoPeaM… i ll try it…
I dont know what am missing. getting error in the below formula too…
sorry but can you help me with this.

=IF(AND(K2>J2,K2>I2),“1”,“”)

=IF(U2=“1101”,IF(AND(K2<=I2,K2<=J2,MONTH(J2)<>MONTH(K2),E2<>“O”),“”,IF(AND(E2=“O”,K2<=I2,K2<=J2),J2,K2)),K2)

[PlutoPeaM (Bhudis Wittayanusit)]

@oshan

=IF(U2=“1101”,IF(AND(K2<=I2,K2<=J2,MONTH(J2)<>MONTH(K2),E2<>“O”),“”,IF(AND(E2=“O”,K2<=I2,K2<=J2),J2,K2)),K2)

Try this @oshan ,

1. “=IF(AND(K2>J2,K2>I2),” + “”“1"”" + “,” + “”“”“” + “)”
2. “=IF(U2=”+“”“1101"”" + “,IF(AND(K2<=I2,K2<=J2,MONTH(J2)<>MONTH(K2),E2<>” + “”“O”“” + “),” + “”“”“” + “,IF(AND(E2=” + “”“O”“” + “,K2<=I2,K2<=J2),J2,K2)),K2)”

[oshan (Oviya S)]

thanks a lotttt