"IF" formula for Pass or Fail column

David Soto

Hi,

I'm making a quiz and want the Pass? column to say Pass or Fail if the Grade column is equal to or greater than 3. It keeps coming back as unparsable. Can I get some assistance with the formula?

Formula: =IF(Grade@row>=3,Pass,Fail)

Thanks,

David

Jeff Reisman

@David Soto

You're almost there, you just need to add spaces around your operators and after your commas, and quotes around your text:

=IF(Grade@row >= 3, "Pass", "Fail")

You'll want to also make sure that your Grade@row value is a number value and not text value of a number. There's a difference between 3 and '3. So however you are calculating your grade, make sure it's a number or this formula will throw an error like #INVALID DATA TYPE. *

*If you get this error, try wrapping your reference to Grade@row in a VALUE function to change the text value back to a number value:

=IF(VALUE(Grade@row) >= 3, "Pass", "Fail")

Jeff Reisman

@David Soto

You're almost there, you just need to add spaces around your operators and after your commas, and quotes around your text:

=IF(Grade@row >= 3, "Pass", "Fail")

You'll want to also make sure that your Grade@row value is a number value and not text value of a number. There's a difference between 3 and '3. So however you are calculating your grade, make sure it's a number or this formula will throw an error like #INVALID DATA TYPE. *

*If you get this error, try wrapping your reference to Grade@row in a VALUE function to change the text value back to a number value:

=IF(VALUE(Grade@row) >= 3, "Pass", "Fail")