Using the IF (AND) Function

Good Evening Everyone,

If any of you could help on this, I'd be be very appreciative.

So I have 40,000 cells that need to be checked.

I have a web info, demographic, and cv3custom9 fields. It all relates to shipping percentages versus zone shipping.

For ex:

For Shipping Percentages they need to look like this
Web Info Demographic cv3custom9
.09 .09 0.00

For Zone shipping they need to look like this
Web Info Demographic cv3custom9
WI 0 1.00


I need a function that basically says if web info=demographic and ="Zero in cv3custom9" then it should result in a "yes" or even better if the row was highlighted so i could see which one's don't match.

Then for zone shipping, i need a function that says if "State abbrev" = 0, and equals 1 in cv3custom9, then it should result in a "yes" as well or as a highlighted row.

Please let me know!
Thanks for all your help.

christopherhans welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )