=IF(ISERROR(AVERAGE(C6:G6)),"",AVERAGE(C6:G6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"June" wrote:
I've created the following formula:AVERAGE(C6,D6,E6,F6,G6,)
Please help me change this formula to IF function in order to elimnate
#DIV/0! giving me a clean spreadsheet for presentation.