I need a formula that returns the value on column C as "yes" if column A has any text(name) and Column B has "Approved",
also if column B has any other answer, Column C returns as "No"
and if Column B is empty, Column C returns as blank.
here's what I have which doesnt work, this might have a really different formula than what I have:
=IF(ISBLANK(AND(A2,B2)),IF(AND(istext=A2,B2=Approved), "Yes","No"))
any thoughts?
=IF( B2="", "" , IF ( AND(istext(A2),B2="approved"), "yes", "no"))
try adding a sample sheet , with various combinations and the required output needed - see yellow sheet
Last edited by etaf; 11-11-2021 at 03:43 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Let's try this:
Formula:
Please Login or Register to view this content.
If B is empty, the result will be blank regardless of what is in A.
If A is not empty and B is "Approved" then the result will be "Yes"
Any other case not above will give the result "No". By the logic above this means that B is not blank, and either B is not Approved or A is blank.
To confirm my interpretation, I took "column A has any text(name)" to mean that there is some content in A, so I tested to see if it is blank. ISTEXT will return FALSE if A has a number in it.
OMG this is perfect, you are a god.
btw, would it completely change the formula if I add a condition?
like, if Column B has any answer but Column A is empty, C should be empty also.
which formula worked ? Did you not want a number in A to return a yes in C ? as my formula shows - and the examples
=IF( OR( B2="", AND(B2<>"",A2="")), "" , IF ( AND(istext(A2),B2="approved"), "yes", "no"))
Originally Posted by etaf
Yours actually worked, now im just trying to tinker it so that if A is also empty, C should return as blank also, thank you so much
Ok,
example file with new formula added
if that does not do what you want , perhaps you can put some conditions in A & B and result wanted manually entered in C
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks