IF statement for rounded values equalling to zero

[abeginner]

Hi,

I would really appreciate it if someone could help me please.

I've written an IF statement where I want the values to return true if all selected cells equal to zero and false if equal to anything else. The values are rounded to 2 decimal places. However, from 7 decimal places onwards it has other numbers. So for example, currrently it's showing like this:

A1 0.00
B1 0.00

However, if I take them to 7 decimal places it becomes like this (see below) so I guess this is the reason why it's not returning true as the cell in question isn't really zero.

A1 0.0000001
B1 0.0000007

My forumla is:

=IF(AND('Year AB'!G6460=0,'Year AB'!L6460=0,'Year AB'!M6460=0),"All columns are 0","Check for non-zero values")

It obviously is picking up the full value so keeps returning "Check for non-zero values." How can I write my IF statement so it only checks that it is equal to 0 to 2 decimal places (i.e. returning true for 0.00 or -0.00 but returning false for 0.01, 1.23 etc).

I tried to use ABS and ROUND but it didn't work for me and I can't figure out what I'm doing wrong.

Would be most grateful if someone could provide some help.

Many thanks,

 

[Comfy]

=IF(Round(SUM('Year AB'!G6460,'Year AB'!L6460,'Year AB'!M6460),2)=0,"All columns are 0","Check for non-zero values")

Try that.

 

[abeginner]

Thank you soo very much for your help. It worked perfectly.

I am most grateful.

Thank you again.

 

[Comfy]

Thank you soo very much for your help. It worked perfectly.

I am most grateful.

Thank you again.

You're welcome.

 

[steve the fish]

Is it possible to have negative numbers? Because sum then has potential for error.