If function and a range

M

mrsatroy

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(F3>2,"Pass",IF(F3>16,"Fail",IF(F3<16,"Pass"))))
 
T

T. Valko

=IF(F3<2,"Fail",IF(F3>2,"Pass",IF(F3>16,"Fail",IF(F3<16,"Pass"))))

Here's what your formula is "saying" :

=IF(AND(F3>2,F3<16),"Pass","Fail")
 
F

Francis

would you describe what you want to achieve by providing an example?
--
Hope this help

Please click the Yes button below if this post have helped answer your needs

Thank You

cheers, francis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple IF conditions 3
Using SUM(INDIRECT()) 2
conditional formating if and And 2
Checking the results of a number of IF formula 4
IF Function 2
Flatten password file 3
match function with nested if 12
Problem with SET & REF function 0

Top