Hi guys, stuck on this one...
If A2= blank, do nothing
If A2= "none", show 0 (zero)
If A2 contains other text but "none", show 2
I basically have a selection of Data options in a dropdown of a cell, so writing a formula for each option, would be a lengthy formula... Is there other, simpler way, based on given above?
Thanking in advance!
Try this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you sir! Much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks