how do i have a cell with date/time format appear blank when referencing an empty cell

i have a cell with a formula (mm/dd/yy hh:mm format) referencing multiple cells. when one of the referenced cells is left blank, i would like the referencing cell to remain blank. Formula:

=IF(LEN($V323)>0,$V323+$F323,$B323+$F323)

If cell F323 is blank, i want the cell with the above formula to appear blank

thanks

Hello kendallgriffin,

Try the below formula.

=IF(ISBLANK(F323),"",IF(LEN($V323)>0,$V323+$F323,$B323+$F323))

Thanks!

worked perfect, thanks