Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default if formula with between value as a criteria

This formula works too. Thanks all for your help!

xlm wrote:
Hi AHizon

if you need the formula to only says "OK" when it's equal to each other or
when the difference is between 1 and -1, then that formula doesn't take into
account of your
requirement. if cell A2 = 1 and cell B2 =2 which give you -1, the result is
False
Unless I have made a wrong assumption, then I apologize

try this shorter formula, you need to change the cell's references to yours

=IF(OR((A2=B2),AND(A2-B2<=1,A2-B2=-1)),"ok","off by
$"&ROUND(A2-B2,0))

HTH
Great, that formula did it...Thanks so much!

[quoted text clipped - 11 lines]
between 1 and -1? Please let me know if there is a way to modify this
formula.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
if formula - multi criteria Belinda7237 Excel Worksheet Functions 6 September 3rd 08 03:35 AM
Sum formula for multiple criteria... help? Bob Excel Discussion (Misc queries) 1 April 16th 08 04:43 PM
Sum If Formula with 3 criteria Peanut Excel Worksheet Functions 4 October 12th 07 08:49 PM
multiple criteria formula scott Excel Worksheet Functions 1 September 18th 06 09:08 PM
2 Criteria Formula Coltsfan Excel Discussion (Misc queries) 6 January 16th 06 08:08 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"