Trying to get this if statment to work - microsoft.public.excel.worksheet.functions

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(I44>0,CK44,IF(CP44=Y,CL44))) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1

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(I44>0,CK44,IF(OR(CP44="Y",ISBLANK(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(I44>0,CK44,IF(OR(CP44="Y",LEN(CP44)=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(I44>0,CK44,IF(CP44=Y,CL44))) > > -- > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1 > > . >

OssieMac wrote: >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(I44>0,CK44,IF(OR(CP44="Y",ISBLANK(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(I44>0,CK44,IF(OR(CP44="Y",LEN(CP44)=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". > >> 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 >[quoted text clipped - 13 lines] >> >> =IF(H44=0,CL44,IF(I44>0,CK44,IF(CP44=Y,CL44))) Thank you for your help I will try it out and see if it works -- Message posted via http://www.officekb.com

Similiar Articles:

If/then statement between dates - microsoft.public.access ...
I am trying to draft an if/then statement that will pull a rate from a table and use it to multiply ... in the MileageRate > table. > > Any idea how I can make this work ...

How do I get IIf(IsNull.... to work?? - microsoft.public.access ...
... public.excel =IF(F6="Social Work Supervisor",1,0) I'm trying to ... Can someone help me convert this statement to work ... the previous posts but could not get it to work ...

Multiple IIf with Is Null - microsoft.public.excel
=IF(F6="Social Work Supervisor",1,0) I'm trying to write a function that does ... In that case I need it to say try to set it up with Multiple IIf statements ...

Can't have a null value if another field has text. - microsoft ...
I have tried a few different things to try and get this to work, but I can't seem ... could nest an If...Then statement inside of an If...Then statement. I'll have to try ...

Using an IF statement, based on 2 COUNTIF results (I think ...
What I'm trying to do is the following: Get a count of instances where "# of people" = 1 and "group work" = 0 I'm doing a lot of countif statements, but I don't ...

If statement not displaying text if conditions not met - microsoft ...
Thanks for your help, but I can't get this to work it still ... in a query which feeds into a form. ... I am trying ... with AND, OR, NOT ..... how to use the IF statement in ...

Automatic sequential numbering where a value changes - microsoft ...
I have been trying to do an if statement where if E= "approved", but cannot get the value if true statement to do a count of the number of times there has already ...

IsNotEmpty Range - microsoft.public.excel.programming
Hello...I have a little vb code tht I am trying to get to work with a range of cells. Basically if any of the cells in the range are empty it should...

If statement in macro to find blank cell/value in another cell ...
Trying to find a macro that will allow me to find a ... Hi Kennedy, I tried this and looks to work fine on ... If statement in macro to find blank cell/value in another ...

Insert ascii into Access - microsoft.public.access.queries ...
Hi I'm trying to insert records from a ASCII file to ... on the internet that something like this should work ... Can anybody help me with the exact syntax of this statement.

The Thesis Statement - CT Community Colleges
The principle to remember is that when you try to do too much, you end ... On the other hand, if we discover that our paper has done adequate work but the thesis statement ...

How to use nested IF statements in Excel with AND, OR, NOT ...
I’m trying to write an IF statement to help figure time and apply Shift Diff when applicable. If they work Friday after 5PM and until Monday at 8AM they get SD.

Hostile Work Environment -- 10 Things Bully Bosses do to Cause ...
I had to write a statement on my view and have to get a revised FLMA paper work from my Dr. ... talking about e on the phone, he said "I will try and get ...

Opening Statements - Just Sell®... it's all about sales®
such as trying to get to the boss or getting the bosses name ... especially when i’m closing the opening statement with an alternative time close or something. I work for ...

JavaScript If...Else Statements
Use the if....else statement to execute some code if a ... If the time is less than 20:00, you will get a "Good ... Try it yourself »

7/24/2012 4:06:29 AM