Maybe someone can help. I am using a simple formula where data in C is multiplied by 15 and the answer appears in D, but I want D blank until the number is entered into C.
This can be done in two ways.
You can use an IF formula in your D column. The formula will look like this:
This will basically only calculate if C1 is not blank. If text is entered, the cell will result in an error. You can counteract this by using the following formula instead:
This will write the outcome only if C1 is a number. If C1 is text, such as a space, it will remain blank.
Alternatively you can use conditional formatting to paint the cell white if the cell is blank or not a number. The formula would be the same as written above.