Add blanks into a formula

[Steven1985]

Hi,

I have a formula but i need to add to it.

=NETWORKDAYS(A3,AO3,Controls!A$10:A$47)-0 (MOD(A3,2)>MOD(AO3,1))&" days "&TEXT(AO3-A3,"h:mm")<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Can we add to the beginning so that if the cell AO3 is blank then enter blank in the days taken field (The cell this formula sits). At the moment if its blank it brings back error message #VALUE.<o></o>

 

[Dannyh1]

Hi Try,


=IF(AO3="","",NETWORKDAYS(A3,AO3,Controls!A$10:A$47)-0 (MOD(A3,2)>MOD(AO3,1))&" days "&TEXT(AO3-A3,"h:mm"))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[jim may]

Try...

=IF(AO3="","",NETWORKDAYS(A3,AO3,Controls!A$10:A$47)-0 (MOD(A3,2)>MOD(AO3,1))&" days "&TEXT(AO3-A3,"h:mm"))

 

[Steven1985]

Thats worked fine.

Many Thanks for your help.