Prev: Need help with formulae comparing date-based numbers
Next: Looking for a Function? similar to LEFT
From: mrsatroy on 16 Mar 2010 12:04
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"))))
--
mrsatroy
From: T. Valko on 16 Mar 2010 12:16
>=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")

--
Biff
Microsoft Excel MVP


"mrsatroy" <mrsatroy(a)discussions.microsoft.com> wrote in message
news:234B67D4-A5AE-48AC-A687-AEA86C47283E(a)microsoft.com...
>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"))))
> --
> mrsatroy


From: Bob Phillips on 16 Mar 2010 12:16
How about this

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

--

HTH

Bob

"mrsatroy" <mrsatroy(a)discussions.microsoft.com> wrote in message
news:234B67D4-A5AE-48AC-A687-AEA86C47283E(a)microsoft.com...
>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"))))
> --
> mrsatroy


From: Francis on 16 Mar 2010 12:28
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





"mrsatroy" wrote:

> 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"))))
> --
> mrsatroy
From: Bob Phillips on 16 Mar 2010 13:07
That first 2 should be F2 not just 2.

--

HTH

Bob

"Bob Phillips" <bob.phillips(a)somewhere.com> wrote in message
news:OnSrNQSxKHA.3304(a)TK2MSFTNGP06.phx.gbl...
> How about this
>
> =IF(OR(2>16,F2<2),"Fail","Pass")
>
> --
>
> HTH
>
> Bob
>
> "mrsatroy" <mrsatroy(a)discussions.microsoft.com> wrote in message
> news:234B67D4-A5AE-48AC-A687-AEA86C47283E(a)microsoft.com...
>>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"))))
>> --
>> mrsatroy
>
>


 | 
Pages: 1
Prev: Need help with formulae comparing date-based numbers
Next: Looking for a Function? similar to LEFT