C
christopherp
HI There,
I am trying to setup an if statement that only returns a result afte
all marks for the semester have been entered but I now have too man
tests in the formula.
I have tried to use an AND statement at the beginning of the formul
but I have had no luck so far.
Any help would be appreciated.
See below
=IF(E21="","incomplete",IF(E24="","incomplete",IF(E25="","incomplete",IF(E26="","incomplete",IF(E27="","incomplete",IF(E20>=80%,"Hig
Distinction",IF(E20>=70%,"Distinction",IF(E20>=60%,"Credit",if(e20=<50%,"fail"))))))))
:confused
I am trying to setup an if statement that only returns a result afte
all marks for the semester have been entered but I now have too man
tests in the formula.
I have tried to use an AND statement at the beginning of the formul
but I have had no luck so far.
Any help would be appreciated.
See below
=IF(E21="","incomplete",IF(E24="","incomplete",IF(E25="","incomplete",IF(E26="","incomplete",IF(E27="","incomplete",IF(E20>=80%,"Hig
Distinction",IF(E20>=70%,"Distinction",IF(E20>=60%,"Credit",if(e20=<50%,"fail"))))))))
:confused