False Value removal [Closed]

Report
-
 Blocked Profile -
Hello,

How to remove false value if I use below formula



=IF($K4="Urban",IF(N4>0,1,0))

1 reply


You define the false value.

The syntax for if is:
=if (logic-test, true, false)

If you look at your formula, ypu have not defined the false value. It should be

=IF($K4="Urban",IF(N4>0,1,0),"this is your false value")


Have fun!