| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Hybrid Mode
