Forum Discussion
Only show if there is a date in column
I want to only show the $ amount in Column A if there is a date. Everything I try I get an error. Here is the formula that I have that is totaling the amount now but the same amount shows all the w...
Taking @Subodh's reply a step further, an Excel date is a positive number and so will evaluate as TRUE if used in a logical statement ( 0 is FALSE). This means that
= IF( A3, D2+B3-C3, " " )
will do the same job. Mind you, I would prefer to read a formula such as
= IF( date, priorBalance+credit-debit, "-" )
but that is personal taste.
If we use the logical condition that way, the formula may return an error if the cell being checked, in this case A3, contains a string or A3 contains a formula which returns a blank string ("").