Forum Discussion
Solved
Blank cell after formula
I am trying to return a blank cell in place of #DIV/0! where there are no numbers in Cube 1/2/3 cells - I have tried to use two formulas, AVERAGE and IF but it's not working, please assist??
| 7 Days | 14 Days | 28 Days | |||||||||
| Average MPa (7 days) | Average MPa (14 days) | Average MPa (28 days) | Cube 1 | Cube 2 | Cube 3 | Cube 1 | Cube 2 | Cube 3 | Cube 4 | Cube 5 | Cube 6 |
| #DIV/0! | 40.6 | #DIV/0! | 41.3 | 40.4 | 40.2 | ||||||
| #DIV/0! | 39.2 | #DIV/0! | 40.3 | 38.7 | 38.7 | ||||||
| 34.0 | #DIV/0! | #DIV/0! | 33.9 | 34.5 | 33.5 | ||||||
| 33.7 | #DIV/0! | #DIV/0! | 33.4 | 32.9 | 34.9 | ||||||
| #DIV/0! | #DIV/0! | 40.1 | 39.6 | 39.8 | 40.8 | ||||||
| #DIV/0! | #DIV/0! | 40.2 | 39.2 | 40.1 | 41.4 |
Sue_Simmonds Have a look at the attached file. The formula is in the green shaded cell and it's referring to the yellow shaded range.
7 Replies
Sue_Simmonds Use =IFERROR( < your formula > , "")
- Hello Riny - many thanks for coming online to assist me.
My current formula is basic - +AVERAGE(J8:L8) - would it need to look like this - =IFERROR(< AVERAGE(J8:L8)>,"")
tA
sUE- SORRY MY CURRENT FORMULA IS =AVERAGE(J8:L8)
