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 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
7 Replies
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.
Microsoft has a good example about nested IF()
https://support.microsoft.com/en-us/office/if-function-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8
- Close - I want to check a certain value has been reached in one cell before adding another cell value to it to then display a grade.... so basically test 1 student got a x amount then in test 2 student got x this means final grade of Y to be displayed.
