Previous Topic Next Topic

False Value removal

Closed
Jumita - Aug 9, 2019 at 06:39 AM
 Blocked Profile - Aug 9, 2019 at 07:10 AM
Hello,

How to remove false value if I use below formula



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

1 response

Answer 1 / 1
Blocked Profile
Aug 9, 2019 at 07:10 AM
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!
0

Similar discussions

Samsung gt-e1205y phone lock reset
Abby -
BunoCS -

1 response
Samsung gt e1205y forgot password
Makotech -
Ambucias -

1 response
how to get rid of trojan virus
ziggy7 -
speedy -

74 responses
how do i hard reset samsung GT1205Y phone lock when its off
mussolini -
MaxStart -

1 response
Quick heal removal tools
vyas -
Ambucias -

1 response