Sept 2020 Paper 1

Discussion in 'CP2' started by rlsrachaellouisesmith, Sep 7, 2022.

  1. rlsrachaellouisesmith

    rlsrachaellouisesmith Ton up Member

    Hi

    A basic question but would best practice be to not use IFERROR function but instead use IF(CoG=0,0,AVERAGEIFS formula). This is on the Data Analysis sheet.

    Thank you
     
    rlsrachaellouisesmith, Sep 7, 2022
    #1
  2. Sarah Byrne

    Sarah Byrne ActEd Tutor Staff Member

    I don't think it matters which way you do this as long as it is documented clearly.
     
    Sarah Byrne, Sep 9, 2022
    #2

Share This Page