Multiple If statements

[dvya]

How do I combine these 2 if statements:

=if(and(J2<0.01,O2<0.01),"CHECK","")
=if(and(J2>0.01,O2>0.01),"CHECK","")

What i am trying to do is an error check. I need a value in either J2 or O2. I want to be warned if either they both have a value or if they are both missing a value.

So my formula should do the following:

When J or O has a value - show nothing
When both J & O have a value - "CHECK"
When both J & O are empty - "CHECK"

The reason why i have 0.01 is that because of other formulas on the sheet the cell may show 0.00 so i cant use the ISBLANK in my formula.

Thanks

[TMS]

Please Login or Register  to view this content.