IF Function

[Alma]

What is wrong with this formula:

=IF((I2>=500)*AND(S2>=15)*AND(N2="CPSTART")*OR(N2="CPRESUM"),1,0)

THANKS

[Gary L Brown]

=IF(or(and(I2>=500,S2>=15,N2="CPSTART"),N2="CPRESUM"),1,0)

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Alma" wrote:

>
> What is wrong with this formula:
>
> =IF((I2>=500)*AND(S2>=15)*AND(N2="CPSTART")*OR(N2="CPRESUM"),1,0)
>
> THANKS
>
>
> --
> Alma
> ------------------------------------------------------------------------
> Alma's Profile: http://www.excelforum.com/member.php...o&userid=19335
> View this thread: http://www.excelforum.com/showthread...hreadid=506849
>
>

[Alma]

Not working. Formula is showing 1 when CPRESUM is less than 500.
CPSTART is fine.
Thanks

[Gary L Brown]

Maybe putting it in words would help to figure out what you're trying to
accomplish. That said, try...
=IF(and(I2>=500,S2>=15,or(N2="CPSTART",N2="CPRESUM")),1,0)

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Alma" wrote:

>
> Not working. Formula is showing 1 when CPRESUM is less than 500.
> CPSTART is fine.
> Thanks
>
>
> --
> Alma
> ------------------------------------------------------------------------
> Alma's Profile: http://www.excelforum.com/member.php...o&userid=19335
> View this thread: http://www.excelforum.com/showthread...hreadid=506849
>
>

[Alma]

I am trying to count all the lines that have
column I - balance > $ 500 AND
column S- are > 15 days old AND
column N - have CPSTART OR CPRESUM action code .

Thank you

[Gary L Brown]

:O> Great!
The formula I gave you yesterday should work just fine...
=IF(and(I2>=500,S2>=15,or(N2="CPSTART",N2="CPRESUM")),1,0)

The only issues are, do you want "Greater than or Equal To" or just "Greater
than"?
For just "Greater than", change the above formula to...
=IF(and(I2>500,S2>15,or(N2="CPSTART",N2="CPRESUM")),1,0)

Good Luck and Hope this helped :O>,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Alma" wrote:

>
> I am trying to count all the lines that have
> column I - balance > $ 500 AND
> column S- are > 15 days old AND
> column N - have CPSTART OR CPRESUM action code .
>
> Thank you
>
>
> --
> Alma
> ------------------------------------------------------------------------
> Alma's Profile: http://www.excelforum.com/member.php...o&userid=19335
> View this thread: http://www.excelforum.com/showthread...hreadid=506849
>
>

[Alma]

It works! Thank you so much for your help Gary!