Trying to come up with a formula that will only return a value if 2 colums are equal. Some times the colums will include 0's, or be blank. I've attached a sample file to show what I am trying to do.
Any help will be greatly appreciated.
Trying to come up with a formula that will only return a value if 2 colums are equal. Some times the colums will include 0's, or be blank. I've attached a sample file to show what I am trying to do.
Any help will be greatly appreciated.
is this what you need?
=IF(OR(B2=0,C2=0,B2="",C2=""),"N",IF(B2=C2,"Y","N"))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you Sambo kid, with a slight modification it works GREAT!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks