C
chuck72352
Is there an easy way to modify the formula below to only give a result
ONLY if all five cells (C4 through C8) have values entered?
=IF(ISERROR(ROUND(AVERAGE(C4:C8),1)),"",ROUND(AVERAGE(C4:C8),1))
Thank you,
Chuck
ONLY if all five cells (C4 through C8) have values entered?
=IF(ISERROR(ROUND(AVERAGE(C4:C8),1)),"",ROUND(AVERAGE(C4:C8),1))
Thank you,
Chuck