How to set an alarm when there is a difference between cells?
 

Hi,

I need your help to make a formula gives me alert when the difference
between 3 cells is more that 1 point!

For example: If A1=1, A2=2, and A3=3 then this is fine,
But if A1=1, A2=2, and A3=4 so I want to see an alarm on A3 when the
difference between A1, A2 & A3 is more than 1

Thanks in advance.

Khaledity

How to set an alarm when there is a difference between cells?
 

If you mean for Conditional Formatting then try:

=MAX(A1:A3)-MIN(A1:A3)2

If you mean to show an error message in a cell then try:

=IF(MAX(A1:A3)-MIN(A1:A3)2,"Too Big!","")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Khaledity" wrote in message
ups.com...
Hi,

I need your help to make a formula gives me alert when the difference
between 3 cells is more that 1 point!

For example: If A1=1, A2=2, and A3=3 then this is fine,
But if A1=1, A2=2, and A3=4 so I want to see an alarm on A3 when the
difference between A1, A2 & A3 is more than 1

Thanks in advance.

Khaledity

How to set an alarm when there is a difference between cells?
 

=IF(A2-A1=A3-A2,"","more than 1")

"Khaledity" wrote:

Hi,

I need your help to make a formula gives me alert when the difference
between 3 cells is more that 1 point!

For example: If A1=1, A2=2, and A3=3 then this is fine,
But if A1=1, A2=2, and A3=4 so I want to see an alarm on A3 when the
difference between A1, A2 & A3 is more than 1

Thanks in advance.

Khaledity

How to set an alarm when there is a difference between cells?
 

"Teethless mama" wrote in message
...
=IF(A2-A1=A3-A2,"","more than 1")

With the OP's data yes but what if the values are A1=4, A2=5 & A3=5?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk