JE McGimpsey

Posts: n/a

One way:

=(A1=--LEFT(A2,FIND("-",A2)-1))*(A1<=--MID(A2,FIND("-",A2)+1,255))

In article ,
Coltsfan
wrote:

Is there a formula that I can use that says if
Cell A1 which is 17 is equal to or between A2 which is 13-20 then 1
otherwise 0?

If anyone could help I would appreciate it.

thanks

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
COUNT IF NOT EQUAL TO ZERO	ellebelle	Excel Worksheet Functions	12	June 24th 05 04:08 PM
ANOVA procedures and t-test equal variance	Noosa	Excel Discussion (Misc queries)	1	May 12th 05 06:09 AM
IF function... not equal to	cj_singer	Excel Worksheet Functions	1	March 24th 05 08:35 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
How to verify that 3 cells are equal	Scott	Excel Worksheet Functions	1	November 9th 04 10:24 PM

All times are GMT +1. The time now is 11:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us