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...
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.
