Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

8 points

IF function in Numbers for Mac

I have a cell with two IF expressions in it. I want the if-false outcome to display nothing, not even FALSE as it is doing at the moment when I put opening and closing parantheses for the if-false outcome. It works if I just have one IF expression. Is there something extra I have to do for two IF expressions?

iMac, macOS High Sierra (10.13.3)

Posted on Mar 9, 2018 8:29 AM

Best reply

Barry

Level 9

59,861 points

Posted on Mar 9, 2018 10:26 AM

Hi w,

Your formula tells Numbers what to do if the AF2 IS greater than zero, but doesn't tell it what to do if AF2 is 0 or less:

IF(AF2>0,IF($J2="y",A2,""))

cond 1: AF2>0

true: IF($J2="y",A2,"")
- cond 2: $J2="y"
  - true: A2
  - false: ""
false: not specified, so return FALSE

Adding a 'dothat' part to the first IF may produce what you want:

IF(AF2>0,IF($J2="y",A2,""),"")

Logically, this is the same as 'If AF2 is greater than zero AND $J2 contains "y", A2, otherwise ""'

Which can be expressed in a formula as:

IF(AND(AF2>0,$J2="y"),A2,"")

Regards,

Barry

View in context

IF function in Numbers for Mac

Similar questions