Forum Discussion
IF Formula
I am trying to do an IF formula for if something is greater than or equal to and it will pass/fail. Pretty simple. However in my IF formula, I am selecting a cell that has another IF formula ...
Assuming you have this criteria: if score is greater or equal to 50, pass.. If score less than 50, fail
Your formula will be, for example, =IF(A1>=50,"Pass","Fail")
All the values that is equal to or greater than 50 will return Pass while values below 50 will return Fail.
Just follow the logic and apply to your data.
Your formula will be, for example, =IF(A1>=50,"Pass","Fail")
All the values that is equal to or greater than 50 will return Pass while values below 50 will return Fail.
Just follow the logic and apply to your data.