Posted to microsoft.public.excel.worksheet.functions

Ivano

Posts: n/a

Using IF function for inbetween cell values

Hi,
I would like to test a cell and run a formula if the cell is inbetween two
values. For example.
IF(A1 <is inbetween values 1 and 100,"YES", "NO")
I can't figure out how to tell Excel the inbetween part? do I use A1=1:100
or 1<A1100?

Thanks a lot for your help,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Function to select second-to-last non-empty cell	sandr5	Excel Worksheet Functions	0	March 21st 06 03:13 PM
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM
Possible Lookup Table	Karen	Excel Worksheet Functions	5	June 8th 05 09:43 PM
up to 7 functions?	ALex	Excel Worksheet Functions	10	April 12th 05 06:42 PM
set hypothetical values for a cell	chris8715	Excel Worksheet Functions	1	February 22nd 05 05:18 PM

All times are GMT +1. The time now is 07:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us