Posted to microsoft.public.excel.worksheet.functions

mrsatroy

external usenet poster

Posts: 6

If function and a range

I have the following function and it is only half working for me as my
arguements seem to contradict one another as I want to see if my number falls
within a specified range. Any suggestions appreciated

=IF(F3<2,"Fail",IF(F32,"Pass",IF(F316,"Fail",IF( F3<16,"Pass"))))
--
mrsatroy

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
Range of a function	Daniel	Excel Discussion (Misc queries)	3	September 18th 07 08:48 AM
Function Range	Rich	Excel Worksheet Functions	6	September 2nd 07 05:58 PM
DBSUM function but with function as criterion, not a range	corne_mo	Excel Worksheet Functions	3	July 13th 07 12:20 PM
range function	Felicia	Excel Discussion (Misc queries)	2	January 29th 07 06:10 PM
Between/ range function	sanpanico	Excel Discussion (Misc queries)	3	April 28th 05 10:25 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us