Hi All,
Forgive me if there is a post explaining this but i can't seem to find one.
I am trying to convert a result from an nf function to a different value ie.
The following formula nf(E8;"Bill of Materials") returns "False" or "True" as the result depending on what it finds.
I need to convert this to either "No" or "Yes"
I have tried =IF(NF(E8;"Bill Of Materials")="False";"No";"Yes") but always returns "Yes" for some reason.
Please can someone assist me with this.
Many thanks
Thomas
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Thomas,
I think your Excel formula is wrong.
The word "False" may not be quoted. Then it should work.
Good luck,
Bert. -
Jet Reports Historic Posts Hi Bert,
That did it - so simple i could kick myself
Thanks a lot
Please sign in to leave a comment.