IFs, or AND?

[Auxie]

Hi all,

I'm trying to tidy up and speed up a spreadsheet by having pre-populated formula already to use in specific cells. The code below works perfectly when F9 has a value, however I want the cell to appear blank if F9 doesn't contain a value - currently it will spit out "30658"

I've attempted to use and IFs but it remained the same, I have also attempted to use AND but it kept returning errors. Any help would be greatly appreciated.

=IF(F9<1,NETWORKDAYS(D9,NOW(),$N$9:$N$30)-15,"Delivered")

Regards,
Auxie

 

[Joe4]

Try nesting your IF, i.e.

[FONT=monospace]=[COLOR=#ff0000]IF(F9="","",[/COLOR]IF([/FONT][FONT=monospace]F9[/FONT][FONT=monospace]<[/FONT][FONT=monospace]1[/FONT][FONT=monospace],[/FONT][FONT=monospace]NETWORKDAYS[/FONT][FONT=monospace]([/FONT][FONT=monospace]D9[/FONT][FONT=monospace],[/FONT][FONT=monospace]NOW[/FONT][FONT=monospace](),[/FONT][FONT=monospace]$N[/FONT][FONT=monospace]$[/FONT][FONT=monospace]9[/FONT][FONT=monospace]:[/FONT][FONT=monospace]$N[/FONT][FONT=monospace]$[/FONT][FONT=monospace]30[/FONT][FONT=monospace])-[/FONT][FONT=monospace]15[/FONT][FONT=monospace],[/FONT][FONT=monospace]"Delivered"[/FONT][FONT=monospace]))[/FONT]

 

[Auxie]

Try nesting your IF, i.e.

[FONT=monospace]=[COLOR=#ff0000]IF(F9="","",[/COLOR]IF([/FONT][FONT=monospace]F9[/FONT][FONT=monospace]<[/FONT][FONT=monospace]1[/FONT][FONT=monospace],[/FONT][FONT=monospace]NETWORKDAYS[/FONT][FONT=monospace]([/FONT][FONT=monospace]D9[/FONT][FONT=monospace],[/FONT][FONT=monospace]NOW[/FONT][FONT=monospace](),[/FONT][FONT=monospace]$N[/FONT][FONT=monospace]$[/FONT][FONT=monospace]9[/FONT][FONT=monospace]:[/FONT][FONT=monospace]$N[/FONT][FONT=monospace]$[/FONT][FONT=monospace]30[/FONT][FONT=monospace])-[/FONT][FONT=monospace]15[/FONT][FONT=monospace],[/FONT][FONT=monospace]"Delivered"[/FONT][FONT=monospace]))[/FONT]

So simple, feel foolish for not spotting that ! - Thanks.

 

[Joe4]

You are welcome!