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

Answerbag | Terms of Service | Privacy Policy