Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get this if statment to work
I have excel 2000. I am trying to get this formula to work. It does not give
me any errors or anything It just will not return the number in the cell that it references Cell CJ44 has the formula Here is an example of the cells CJ44 formula CL44 has =IF((I44=0),0,INT((I44-10)/2)) (the value in their is 0) CK44 has =IF((H44=0),0,INT((H44-10)/2)) (the value in their is -1) CP44 (the value in their is Y) but I want it to fuction normally if their is nothing (blank) in cell CP44 So this is what I have written, but the value does not return to what I want it to be. =IF(H44=0,CL44,IF(I440,CK44,IF(CP44=Y,CL44))) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201006/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get this if statment to work
Firstly if Y is a value in cell then it needs to be enclosed in double quotes in the formula. Anyway do I interpret your question correctly that you want to test for either "Y" or Blank Cell at CP44. If so, then try the following. =IF(H44=0,CL44,IF(I440,CK44,IF(OR(CP44="Y",ISBLAN K(CP44)),CL44))) I think that ISBLANK function is available in xl2000 but just in case it is not then could use the following. =IF(H44=0,CL44,IF(I440,CK44,IF(OR(CP44="Y",LEN(CP 44)=0),CL44))) Both formulas will return FALSE if it gets to the last IF statement and CP44 is not blank and has a value other than "Y". -- Regards, OssieMac "Cerealkiller via OfficeKB.com" wrote: I have excel 2000. I am trying to get this formula to work. It does not give me any errors or anything It just will not return the number in the cell that it references Cell CJ44 has the formula Here is an example of the cells CJ44 formula CL44 has =IF((I44=0),0,INT((I44-10)/2)) (the value in their is 0) CK44 has =IF((H44=0),0,INT((H44-10)/2)) (the value in their is -1) CP44 (the value in their is Y) but I want it to fuction normally if their is nothing (blank) in cell CP44 So this is what I have written, but the value does not return to what I want it to be. =IF(H44=0,CL44,IF(I440,CK44,IF(CP44=Y,CL44))) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/201006/1 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF, AND statment | Excel Worksheet Functions | |||
if statment | Excel Worksheet Functions | |||
IF Statment | Excel Discussion (Misc queries) | |||
if statment | Excel Worksheet Functions | |||
If statment | Excel Worksheet Functions |