Feb 03 2021 01:36 AM
Hi all,
I have a file with numbers-> IF(B2>5;"ok";not"ok), Those numbers are retrieved via a Vlookup and in the Vlookup I added an IFNA --> if the corresponding name is not in the database, it should not give a N/A but a "0". But in the IF formule, if there is a 0 in the cell, the IF formula doesn't work properly as the IF gives for every 0 a "ok" which should be "not ok" because its <5. I am not able to find out what the problem is.
I hope someone can help me.
Many Thanks.
Liz
Feb 03 2021 02:58 AM
Feb 03 2021 05:43 AM