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
