|
IF Function
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 |
IF Function
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 |
IF Function
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 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 |
IF Function
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 |
IF Function
: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(I2500,S215,or(N2="CPSTART",N2="CPRESUM") ),1,0) Good Luck and Hope this helped :O, -- Gary Brown 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 |
IF Function
It works! Thank you so much for your help Gary! :) -- Alma ------------------------------------------------------------------------ Alma's Profile: http://www.excelforum.com/member.php...o&userid=19335 View this thread: http://www.excelforum.com/showthread...hreadid=506849 |
| All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com