I get a token literal expected error, not sure what I am missing.
It highlights the ' o" ' part of the No
I am trying to change any value that is <> than "No" to be "Yes"
also tried
It highlights the ' o" ' part of the No
VBA Code:
=if [UPC]= <> "No" then "Yes"[UPC]
I am trying to change any value that is <> than "No" to be "Yes"
also tried
VBA Code:
=if [UPC] <> "No" then "Yes"