View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formula contains "" but cell still shows a value

Maybe

=IF(AND(A13<"",G13<""),NETWORKDAYS(B13,G13,Holid ays!$B$1:$B$28),"")

Mike

"Glenn" wrote:

I've "inherited" a workbook, and it contains the formula
=IF(A13<"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$2 8),"")

The problem is that G13 has no value but the results cell has a value of
-28053 which makes no sense. A13 has a value.

Can someone tell me how to have the cell be blank when no value is in G13?

Thank you