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

[Khaledity]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

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

 

[Sandy Mann]

=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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk