Excel Geeks Pt 2

[chris-red]

=IF(AND(m3-n3>-0.00001,m3-n3<0.00001)"Same","Different")

Why doesn't this work?

I want to comapre 2 cells and if they are the same or within 0.00001 of each other print same otherwise print different.

I was following this guide

https://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/

HALP!
____________________
Well, you know what they say. If you want to save the world, you have to push a few old ladies down the stairs.
Skudd:- Perhaps she just thinks you are a window licker and is being nice just in case she becomes another Jill Dando.
WANTED:- Fujinon (Fuji) M42 (Screw on) lenses, let me know if you have anything.

[Kickstart]

Hi

Don't you have a missing comma after the inner close brackets?

=IF(AND(m3-n3>-0.00001,m3-n3<0.00001),"Same","Different")

All the best

Keith
____________________
Traxpics, track day and racing photographs - Bimota Forum - Bike performance / thrust graphs for choosing gearing

[chris-red]

Love you
____________________
Well, you know what they say. If you want to save the world, you have to push a few old ladies down the stairs.
Skudd:- Perhaps she just thinks you are a window licker and is being nice just in case she becomes another Jill Dando.
WANTED:- Fujinon (Fuji) M42 (Screw on) lenses, let me know if you have anything.