Using Plus Minus in IF Formula

**ppdominic** · 02-15-2014, 07:08 AM

I am looking for a help to write a Formula in the following scenario

Suppose In Cell A1 & A2 two numbers are there.
I want to show a message in Cell A3, Say "Err" if the difference is higher than 1 and lower than -1
If I need only to make one condition, say, higher than 1, I can write the formula as given below
=if((A1-A2)>1,"Err","").
But I need to integrate second condition. I request the members who know the solution, publish an answer.
Best Regards
Dominic

**AZ-XL** · 02-15-2014, 07:14 AM

Hi
a3 cell =IF(OR((A1-A2)>1,(A1-A2)<-1),"Err","")

**ppdominic** · 02-15-2014, 07:45 AM

There seems to be a minor mistake. The given formula is not working

**XOR LX** · 02-15-2014, 07:57 AM

Hi,

I presume by "the difference is higher than 1 and lower than -1" you actually intended or, not and (it can't be simultaneously >1 and <-1)?

=IF(ABS(A1-A2)>1,"Err","")

Regards

**ppdominic** · 02-15-2014, 09:32 AM

Hi,
The suggestion is working. Thanks
Dominic

Using Plus Minus in IF Formula

LinkBack

Thread Tools

Rate This Thread

Display

Using Plus Minus in IF Formula

Re: Using Plus Minus in IF Formula

Re: Using Plus Minus in IF Formula

Re: Using Plus Minus in IF Formula

Re: Using Plus Minus in IF Formula

Thread Information

Users Browsing this Thread

Similar Threads

Formula to minus VAT at 20%

[SOLVED] How to get the correct (minus) answer for a minus raised to a power

[SOLVED] I neeed help on changing a minus figure so it does not show a minus

[SOLVED] CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS

how do you count a column minus dupicates minus blanks.

Bookmarks

Bookmarks

Posting Permissions