i need some help on "if+and" ?

[kelvin_9]

with my logical_test, what formula should i use/any macro that can apply to my request in a cell result?


if+and cell="full" but non-blank, return cell value
if+and cell="full" but blank, return "no fitting"



if+and cell="0" but non-blank, reutrn "wrong deploy"
if+and cell="0" but blank, return "correct"


thanks anyone

 

[igold]

Perhaps you could rephrase this by defining what you mean by "full", blank and non-blank. Is "full" supposed to be that exact string, and is the blank (define blank) referring to the same cell or a different cell.

 

[kelvin_9]

Perhaps you could rephrase this by defining what you mean by "full", blank and non-blank. Is "full" supposed to be that exact string, and is the blank (define blank) referring to the same cell or a different cell.

i apologize for the mis-understanding and my english isnt very good, i hope you would understand what i need and help me out.
i have uploaded another file to my cloud and here are my request

<dl style="box-sizing: inherit; margin-right: 0px; margin-bottom: 1.5em; margin-left: 0px; color: rgb(51, 51, 51); font-family: Arial, Helvetica, sans-serif; background-color: rgb(252, 252, 252);"><dd id="direct-dl-link" style="box-sizing: inherit; margin: 0px 0px 0.8em; padding: 0px; color: rgb(34, 34, 34);">http://kel.ddns.net/f/a7b687a742/?raw=1</dd></dl><button id="send-download-link" style="margin: 0px; font-size: 13px; line-height: 19px; font-family: Arial, Helvetica, sans-serif; color: rgb(51, 51, 51); overflow: visible; cursor: pointer; touch-action: manipulation; border-radius: 2px; padding-top: 5px; padding-bottom: 5px; overflow-wrap: break-word; background-image: -webkit-linear-gradient(top, rgb(250, 250, 251), rgb(238, 238, 238)); background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border-width: 1px; border-style: solid; border-color: rgb(197, 197, 197);"></button>i get my team's schedule from my partner once a week, in column B-H @ sheet_result.
i try to use "if+and"? to testify the result that my partner deploy to my team which is/isnt fulfill my team's availability with sheet_availability

sheet_availability
always come with "full", "0", before/after specific time for identify
full: whole day available, example at sheet_availability, row 2
0: unavailable, example at sheet_availability, row 3
specific time: before/after is a must, example at sheet_availability, row 4

sheet_result
for ada
when she is available on sunday/monday/tuesday anytime, the outcome need to be return with a time, example at row 2 column B
when she dont have a schedule deployed, the outcome need to be "no-fitting", example at row 2 column G
for arkies
when she is unavailable on sunday but my partner wrongly deployed, the outcome i want it "wrong/no-submit", example at row 3 column F
finally for bella
when she is only available for the time before 20:00 on sunday, the outcome need to be before 20:00, example at row 4 column B
*but sometime it might be wrong deployed by my partner, example at row 4 column B, then, i want the outcome will bold? colored? or something that i can easily identify

i hope this can be easier for your understanding and THANKS FOR THE GREAT HELP AS ALWAYS, appreciated!

 

[kelvin_9]

anyone know or too difficult to get this?

 

[igold]

I would like to say that your Post #3 cleared things up for me (I did not look at your link), but unfortunately I am not understanding your requirement.

 

[kelvin_9]

not understanding my requirement? What does that means?
how can I post my workbook/cell here? or is it my link doesn't work? I really want someone help me out.