The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
Where I have the cells labelled 6,8,10,12 etc under 1,2,3,4....if there is a blank cell I don't want any measurements from A-z. For example the cells 40, 45 50, 55 would be blank. Is there a formula to do this?
iMac 27″, macOS 10.14
I hope I understood you correctly.
For these examples the cells B1 to E1 are formate as numbers!
You can use the IF formula.
Option A:
It will check if cell B$1 contains a value that is >= 1, if yes it will run a calculation, if not it will return an empty text ""
Option B:
It will check if cell B$1 contains any number, if yes it will run a calculation, if not it will return an empty text ""
I hope I understood you correctly.
For these examples the cells B1 to E1 are formate as numbers!
You can use the IF formula.
Option A:
It will check if cell B$1 contains a value that is >= 1, if yes it will run a calculation, if not it will return an empty text ""
Option B:
It will check if cell B$1 contains any number, if yes it will run a calculation, if not it will return an empty text ""
AMAZING! THANK YOU.
Leave cells blank
