IF AND NOT OR function help - - Computer Learning Zone


	Back to Excel Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

IF AND NOT OR function help

Felicia Smith

2 years ago

I have a spreadsheet tracking ads purchased for our annual charity event. 4 columns contain an ad size if the company purchased an ad for that year. I need to be able to sort the entire list by #1. companies with ads confirmed for this year #2. companies who have purchased in the past 3 years #3. prospects that have not purchased.

I have used conditional formatting to bring grp #1 to the top. I put a hidden column at the end that I want excel to put an "x" in if they are a prospect - grp #3 (no words in any of the 4 columns). I have googled and played with the formula for several hours, and I cannot figure it out. Here is one I've tried.

=IF(AND(F3=ISBLANK,G3=ISBLANK,H3=ISBLANK,I3=ISBLANK),"x"," ") gives me #VALUE! error. Can someone help me with how to do this? Is this the best way to do it?

	Adam Schwanz @Reply 2 years ago
`=IF(AND(ISBLANK(F3), ISBLANK(G3), ISBLANK(H3), ISBLANK(I3)), "x", " ")`

	Kevin Robertson @Reply 2 years ago
ISBLANK is a function and should be treated as such. `=IF(AND(ISBLANK(F3),ISBLANK(G3),ISBLANK(H3),ISBLANK(I3)),"x"," ")`

	Kevin Robertson @Reply 2 years ago
Adam beats me to the punch :)

	Felicia Smith OP @Reply 2 years ago
I FINALLY figured it out!!!! Yay!!!!! Here it is for anyone else who is doing something like this. (I'm not sure I UNDERSTAND it totally. lol) =IF(AND(ISBLANK(F188:I188)),"x","")

	Felicia Smith OP @Reply 2 years ago
oops. I didn't see the responses until I submitted mine. thank you for the help!!!! As always, there is more than one way to do these things. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Excel Forum.

Next Unseen

New Feature: Comment Live View