Question on formual if two cell values fall within 3 of each other

E

easybpw

Active Member
Joined
Sep 30, 2003
Messages
437
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hello,

Is there a formula that will look at two specific cells, in this example A1 = 2 & C1 = 5, and say if A1 and C1 differ by +/- 3 or less then D1 = "Y". If they don't meet the criteria then the cell would just be blank. Is this possible?

Thank in advance for the help.

Bill
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
How about
=IF(ABS(A1-C1)<=3,"y","")
 
Upvote 0
Thanks! Didn't even think of that formula.

Bill
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
macro to refresh worksheet until cell meets a value
Replies
3
Views
436
Anthony47
A
P
  • Solved
VBA to keep a running log of changes to specific cell
2 3
Replies
20
Views
914
Joe4
Joe4
N
  • Question
Two different tables - 4 columns each
Replies
8
Views
271
Fluff
Fluff
L
  • Solved
Evaluate each cell in a row against two other rows using VBA
Replies
5
Views
361
mumps
mumps
R
  • Solved
Data Validation
2
Replies
19
Views
1K
dreid1011
dreid1011

Forum statistics

Threads
1,216,077
Messages
6,128,673
Members
449,463
Latest member
Jojomen56

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top