Forum Discussion

tfsmarnie's avatar
tfsmarnie
Copper Contributor
Mar 20, 2020

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 in and seems to be reading a nil value so my pass/fail returns wrong. Is it possible to do what I need to do?

excel

4 Replies

  • tfsmarnie's avatar
    tfsmarnie
    Copper Contributor
    Mar 21, 2020

    Don't worry all I figured it out.

    All I had to do was put VALUE in front of my original IF formula and it gave it value - simple as that  

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 21, 2020

    tfsmarnie 

    My guess is that IF() in another cell for some conditions returns empty string =IF(condition, result, "").

    In current cell IF() takes this result, compare with something and returns Pass or Fail. 

    If first IF returns empty string, that's not null and not zero, that's text. And in Excel any text is more than any number in comparing, i.e. ="">60 returns TRUE

  • Abiola1's avatar
    Abiola1
    MVP
    Mar 21, 2020
    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.

Resources