Menu
Ask a question Report

False Value removal

- - Latest reply: ac3mark
Posts
12936
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
September 3, 2019
 - Aug 9, 2019 at 07:10 AM
Excel Ask a question Report
Hello,

How to remove false value if I use below formula



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

1 reply

Report Respond to ac3mark
Posts
12936
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
September 3, 2019
 1342
0
Thank you
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!
Respond to ac3mark
Reply Ask a question