Thread: Trying to get this if statment to work
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cerealkiller via OfficeKB.com Cerealkiller via OfficeKB.com is offline
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

Reply With QuoteReply With Quote