Hello,
I am trying to create a formula that displays "First" when the condition is true and "Second" when the condition is false. The formula is as follows IF ((5>1 and 5<15), "First", "Second"). I however am unsure of how to write this type of formula in the Numbers app on Mac.
It helps to break down the logic behind it:
AND() is a function unto itself, which compares two conditional statements and returns TRUE or FALSE, accordingly.
So to check if two conditions are true:
AND (D2 > 5, E2 < 15)
this will compared the values in cells D2 and E2 and return TRUE or FALSE.
This can then be plugged into your IF() statement to determine which final value to output:
IF(AND(D2>5,E2<12),"First", "Second")
So, following the parentheses, the AND() statement is run first, then depending on the result, the IF() statement selects the appropriate result.
It helps to break down the logic behind it:
AND() is a function unto itself, which compares two conditional statements and returns TRUE or FALSE, accordingly.
So to check if two conditions are true:
AND (D2 > 5, E2 < 15)
this will compared the values in cells D2 and E2 and return TRUE or FALSE.
This can then be plugged into your IF() statement to determine which final value to output:
IF(AND(D2>5,E2<12),"First", "Second")
So, following the parentheses, the AND() statement is run first, then depending on the result, the IF() statement selects the appropriate result.
I replaced "5" with the cell reference "A5"
=IF(AND(A5>1,A5<15),"First", "Second")
Apple Numbers. Using the IF formula to display a String if a number is greater than another number but less than another number.
