Forum Discussion
Solved
Help with Blank or Zero if no Data for Formula.
Hello I have attached a file so that someone can see what I'm referring to. I have two tables, the one on the left has values in the red column from data I place in the green row. The table on th...
=IF(AND(ISBLANK(N4),ISBLANK(P4)),"",ROUNDUP(O12,0))You can try formulas like this which check if the corresponding cells in row 4 are blank.
=IF(AND(ISBLANK(N4),ISBLANK(P4)),"",ROUNDUP(O12,0))You can try formulas like this which check if the corresponding cells in row 4 are blank.
- A quick and dirty way could also be (taking Shingles as an example)
=IF(COUNTBLANK(M4:V5)=20;0;ROUNDUP(O6;0))
But do you want it to be 0 when EVERY column on the green row is empty, or when ANY is ?
