nsnjlacm

Posts: n/a

How I set up as logical test if my range has to be >=2 but <5

I tried to use the formula "IF" to find different rates, one rate is if the #
is = 2 but <5 and give me the error, please help me

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
How do I use Roundup in a logical test in excel	DC	Excel Worksheet Functions	3	March 9th 05 05:27 PM
=IF logical test to search only part of a cell	Robbie in Houston	Excel Worksheet Functions	2	March 5th 05 05:09 AM
Logical test	Sooraj	Excel Discussion (Misc queries)	2	January 25th 05 12:59 PM
change text color based on logical test	T3nMan	Excel Worksheet Functions	1	January 19th 05 04:30 PM
logical test - within a range	esslingerdav	Excel Worksheet Functions	4	November 17th 04 03:13 PM

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

About Us

"It's about Microsoft Excel"