I have created a formula that relies on data input (event attendee numbers) to provide a result. However, until we input our data (number of attendees) in column A, the column where the answer would display (column B) has an error message. How can we hide the error message with a rule?
Iferror will only mask the problem.
If you add a
=IF(A2="","",YOUR FUNCTION) the calculation will not happen and use unnecessary CPU.
This is especially good if you have chain calculations or heavy functions.
The if() will make sure to not do any calculations unless there is a value in A2 and only display empty value in B2.