A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trying to get this if statment to work



 
 
Thread Tools Display Modes
  #1  
Old June 5th, 2010, 07:29 PM posted to microsoft.public.excel.worksheet.functions
Cerealkiller via OfficeKB.com
external usenet poster
 
Posts: 15
Default 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  
Old June 6th, 2010, 08:41 AM posted to microsoft.public.excel.worksheet.functions
OssieMac
external usenet poster
 
Posts: 862
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.