If you want to create a calculation in a cell based on values in another cell and copy it down the rest of the column, what do you do if you want a blank to be returned if the original cell was a blank?
If our original formula was to work out 10% of whatever is in B2, the formula would be:
If B2 was blank, the resulting formula would return an answer of 0.
If we wanted to ensure we returned a blank if B2 was blank, the required formula would be:
The double quote marks indicate that a blank should be returned if the result is true.