Thread: the formula sees the cell with a value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nada nada is offline
external usenet poster
  
Posts: 13
Default the formula sees the cell with a value
hi all,
i used the following equation in Q:Q range and a similar one in P:P range:
=IF(LEN(INDEX(dewanless!O:O,MATCH(urban1!$F25,dewa nless!$E:$E,0)))=0,"",INDEX(dewanless!O:O,MATCH(ur ban1!$F25,dewanless!$E:$E,0)))
and in another range of cells :
=(1000*(SUMPRODUCT((Q2:Q25<"")*(P2:P25))))/(SUMPRODUCT((P2:P25<"")*(Q2:Q25)))
the error value appears if the result of the first equation is a blank cell
either in the Q range or the P range, what should i do?
Reply With QuoteReply With Quote