Make a cell in Numbers register zero
Hi all I have a formula that is running in cells that will only populate when the data is entered in a nother cell.
There is a lot of calculations running in other tables which is taking these empty cells into consideration but because there is an error the cells are showing errors.
Is there a way of saying:
If there is nothing entered into a cell then dont run a calculation on all other cells that relate to it.
Please see screen shot to help explain this better.
So If i enter a name into A11 it bring up the data and populate across the table - but when nothing is entered it is still looking for the data so showing the red box - this effects other tables as well so basically need it to show zero.
Thanks for your help
MacBook Pro 15", macOS 10.14