Formula to nullify value

[amittheexcel]

Hi There,

I need help to generate excel formula for below table.I need to put comments "value Zero" if my column"A" value nullify. below is the table. Please help me to get formula for this.

[TABLE="width: 500"]
<tbody>[TR]
[TD]value[/TD]
[TD]Abs Forumal[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]-400[/TD]
[TD]400[/TD]
[TD]Value zero for 400[/TD]
[/TR]
[TR]
[TD]-400[/TD]
[TD]400[/TD]
[TD]Value zero for 400[/TD]
[/TR]
[TR]
[TD]400[/TD]
[TD]400[/TD]
[TD]Value zero for 400[/TD]
[/TR]
[TR]
[TD]400[/TD]
[TD]400[/TD]
[TD]Value zero for 400[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]500[/TD]
[TD]need to check[/TD]
[/TR]
[TR]
[TD]-500[/TD]
[TD]500[/TD]
[TD]need to check[/TD]
[/TR]
[TR]
[TD]-500[/TD]
[TD]500[/TD]
[TD]need to check[/TD]
[/TR]
[TR]
[TD]-600[/TD]
[TD]600[/TD]
[TD]need to check[/TD]
[/TR]
[TR]
[TD]-600[/TD]
[TD]600[/TD]
[TD]need to check[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

something like

=IF(ABS(Cell)<>400,"Need To Check","0")

 

[amittheexcel]

Hi,

I want to check all rows, like for 400 & 500 if value is coming zero, it shows 0 to comments.

Can we give any other criteria other than 400?

=IF(ABS(Cell)<>400,"Need To Check","0")

 

[mole999]

you can build additional IF statements, obviously I have used cell as to one you are checking and haven't specified where you place the formula

so =IF(ABS(A1)<>400,"Need to Check",0)

 

[amittheexcel]

Hi, This is not something which i want. Basically I want to put comments as "0" if column "A" value nullify. For ex - For 400 there 4 rows with two 400 and two -400. which are nullify. howver for other rows we have 500, -500 & 500 which is not nullify the value to zero. so i want to build a formula in such a way that if my column "A" values gets nullify we should get comment as "0" else "needs to check". Hope you can help me now.