Nov 04 2021 03:23 AM
Hi
I am trying to write a formula that basically does the following:
If Cell A1 has a value of less than 3 = Fail, if cell A1 has a value more than 4 = Pass...
thats easy but I want the same formula to then check cell A2 and see if that has equaled more than 2 (but at the same time still checking that cell A1 is more than 3... to then equal "Merit") finally then checking Cell A3 has a value more than 1 in it and to equal "Dist"
You can guess this for tracking students - so basically if a cell A1 does not meet a value more than 4 then it should not matter if value are in the other cells...
hope that make sense to some one - ive tried a few variations and cant get it to work.
Thanks
Nov 04 2021 03:33 AM
Nov 04 2021 03:44 AM
Nov 04 2021 04:06 AM
That is also close - see attachment, Ive tried using numbers but the issue is basically if a learner fails to complete a P element but still does the M and D work they should get a fail - a simple maths formula overlooks this need to have a points in each element.
Nov 04 2021 04:16 AM
Nov 04 2021 08:05 AM