If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|