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
|