LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 287
Default how do i set formula to be equal to a value plus or minus 1?

i want an if then statement. i have it now so that something happens if x =
y. well, i want the same thing to happen if x = y plus or minus 1. i found
that x is often within .1 or 1 of y and that is close enough for me to want
the something to happen. thanks.
 
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
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
what is the 1 minus in this formula actual doing Kim Shelton at PDC Excel Worksheet Functions 2 November 21st 06 05:08 PM
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
How do I make a column equal a formula in Excel? archllama Excel Discussion (Misc queries) 7 April 11th 06 12:38 AM
How do I get an automatic equal sign to begin the formula bar? scarlette belle New Users to Excel 1 January 5th 06 11:07 PM


All times are GMT +1. The time now is 05:28 PM.

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"