So i need a formula that gives me an answer, but, remains blank if the cells are giving the formula no data to compute. Please see below. This is how far i have gotten, but, i need to add something that says if no entries/no results:
=if(and(l13>3,m13>3,n13>3),"q","u")
THIS WORKS GREAT AS IT SHOWS ME TRUE/FALSE (OR Q/U)
BUT -
WHEN I HAVE BLANK ENTRIES IN THOSE 3 CELLS, IT SHOWS ME "U" WHEN I NEED IT TO SHOW NOTHING AT ALL.
Last edited by ntraviglia; 10-25-2016 at 02:33 PM.
Unfortunately, your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Thread title now changed - thank you!
Last edited by AliGW; 10-25-2016 at 04:38 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Try this ntraviglia
=IF(COUNTA(L13:N13)<>0,IF(AND(L13>3,M13>3,N13>3),"q","u"),"")
@jeversf - Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction then send a private message to them asking for clarification.
All participants:
Please do not post a reply in a thread where there is a request for action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.
Sorry about that. Just checked my email and saw you guys wrote me. i will fix now. Thx.
Try
=IF(COUNT(L13:N13),if(and(l13>3,m13>3,n13>3),"q","u"),"")
Thank you so much. When I typed that in and hot return - it came back #NAMEOriginally Posted by Jonmo1
Which I'm not sure where the error would be.....
Awesome! It DID work! Lol! I typed it in wrong. Thank you soooo much!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks