2 result in the same column

[Cannone_Cannone]

Hi everyone I have a little problem about this formula. In a column called “RESULT” I want the result of this formula.
IF ([F]> [TARGET F], “Out of Range”, “In Range”). I have two more columns that should return me the same result always in the “result” column
IF ([L]> [TARGET L], “Out of Range”, “In Range”). Basically I should link the two formulas together.

[WillowMobileSys]

If it’s only the two, then you can use an OR condition like so:

IF ( OR([F] > [TARGET F], [L] > [TARGET L]) ,
       “Out of Range”, 
       “In Range”)

If you have more conditions then I would recommend using IFS() function.

help.appsheet.com

OR()

Are any true?

help.appsheet.com

IFS()

First-match conditional evaluation

[Cannone_Cannone · Accepted solution]

Thanks for your help, i try but i have this result

IF function is used incorrectly:three inputs should be provided — (condition, if-result, else-result).

[WillowMobileSys]

I was missing a comma after the OR(). I edited the post to include it.

[Cannone_Cannone]

WillowMobileSystems:

IF ( OR([F] > [TARGET F], [L] > [TARGET L]) ,
       “Out of Range”, 
       “In Range”)

thanks a lot!!!