Forum Discussion
Formula help - =If =IF And...
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 s...
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.
