# Formula to nullify value

#### amittheexcel

##### New Member
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.

 value Abs Forumal Comments -400 400 Value zero for 400 -400 400 Value zero for 400 400 400 Value zero for 400 400 400 Value zero for 400 500 500 need to check -500 500 need to check -500 500 need to check -600 600 need to check -600 600 need to check

<tbody>
</tbody>

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### mole999

##### Moderator
something like

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

#### amittheexcel

##### New Member
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

##### Moderator
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

##### New Member
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.

1,089,394
Messages
5,407,983
Members
403,176
Latest member
mehtavish1