format a cell with a formula so an empty reference cell shows blan
I'm using the WORKDAY function. My formula is =WORKDAY(A1,10) to add 10
working days after the date an order is entered to show the due date. How do I keep the cells showing up blank until an order date is entered? Thank you, |
format a cell with a formula so an empty reference cell shows blan
=IF(A1="","",WORKDAY(A1,10))
-- David Biddulph "M2" wrote in message ... I'm using the WORKDAY function. My formula is =WORKDAY(A1,10) to add 10 working days after the date an order is entered to show the due date. How do I keep the cells showing up blank until an order date is entered? Thank you, |
format a cell with a formula so an empty reference cell shows blan
I'm using the WORKDAY function. My formula is =WORKDAY(A1,10) to add
10 working days after the date an order is entered to show the due date. How do I keep the cells showing up blank until an order date is entered? One way: =IF(A1="","",WORKDAY(A1,10)) |
format a cell with a formula so an empty reference cell shows blan
If (A1="",''",your formula)
HTH Otto "M2" wrote in message ... I'm using the WORKDAY function. My formula is =WORKDAY(A1,10) to add 10 working days after the date an order is entered to show the due date. How do I keep the cells showing up blank until an order date is entered? Thank you, |
All times are GMT +1. The time now is 01:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com