You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
In Excel it is possible to create a 'IF AND' formula where a calculation will only happen if two conditions are true. Can anyone tell me if this is possible in Numbers and, if so, how would the formula be written in a cell. Many Thanks.
P.S. I have tried to find this on the net without success so if you know that this is not a feature of Numbers please tell me.
iMac 21.5" 4K, macOS 10.15
Hi Craig,
Both IF and AND functions are supported in Numbers, and work in essentially the same manner.
Syntax: IF(AND(expression1,expression2),if-true,if-false)
'Any' number of expressions can be added to the list in AND. AND will return true only if all expressions return true.
More detail on each othe these fnctions (and the rest of the functions supported in Numbers) is available in the Function Browser. To open the browser, click on any cell in a Numbers table, then type an = to open the Formula Editor (at that cell) and the Function Browser (in the right sidebar. The browser may be browsed by category, or searched by function name. Each entry contains a description of the function, including its syntax, and at least one example of how it can be used in a Numbers Document.
Regards,
Barry
Hi Craig,
Both IF and AND functions are supported in Numbers, and work in essentially the same manner.
Syntax: IF(AND(expression1,expression2),if-true,if-false)
'Any' number of expressions can be added to the list in AND. AND will return true only if all expressions return true.
More detail on each othe these fnctions (and the rest of the functions supported in Numbers) is available in the Function Browser. To open the browser, click on any cell in a Numbers table, then type an = to open the Formula Editor (at that cell) and the Function Browser (in the right sidebar. The browser may be browsed by category, or searched by function name. Each entry contains a description of the function, including its syntax, and at least one example of how it can be used in a Numbers Document.
Regards,
Barry
Many Thanks !
Use of Conditional formula in Numbers
