ANSWERS: 2
-
You can put in conditions in those two cells by using the "IF" operator, as follows; IF(ISBLANK(A1),"",A1+5) IF(ISBLANK(A1),"",A1+15) The "" expression will show nothing in the two cells if A1 is blank.
-
I like to leave guidance to the user about what IS required, so I'd modify AIT's answer as: =IF( OR( ISBLANK(A1), NOT( ISNUMBER( A1))), "Enter Start Date in A1.", A1 + 5) and =IF( OR( ISBLANK(A1), NOT( ISNUMBER( A1))), "Enter Start Date in A1.", A1 + 15), respectively. I also include the other part of the IF statement: "not( isnumber( a1))" in case the user enters text there or anything else that evaluates to zero.
Copyright 2023, Wired Ivy, LLC

by 