View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EnigmaKat EnigmaKat is offline
external usenet poster
 
Posts: 3
Default Using more than one IF function

=IF(AND($U4=DHARMA!G$4,$U40,$O4<"H"),$E4*DHARMA! $H$4+$F4*DHARMA!$I$4,"")&IF($P4<0,$P4*DHARMA!$H$4 +$Q4*DHARMA!$I$4,"")

After several rewrites, this function works and does not return an error
when the cells are blank, but now I can't format the cells that contain this
function. Strange.