I have:

in *Column F* in *Column S* F2 Monday S2 Orange F3 Tuesday S3 Mango F4 Wednesday S4 Grape F5 Thursday S5 Pawpaw F6 Friday S6 Onion F7 Saturday S7 Apple F8 Sunday S8 Plum

My main target in Column S is `Apple`

regardless of what cell reference it occupies.

I want a formula that will capture the following three scenarios:

- If S2 =
`Apple`

and Column F has any day, I want the formula to return`Apple`

. - If any of the cells in Column S has
`Apple`

and the corresponding F cell is blank, I want the formula to return`Apple`

. - If either of the cells in Column F or Column S is empty, I want the formula to return a blank cell.

*Fruits* *Day of week* *Results* Apple Monday Apple [Empty] [Empty] [Empty] Pawpaw Wednesday [Empty] Onion Tuesday [Empty] Apple [Empty] [Empty] instead of Apple:see formula below [Empty] Friday [Empty] Plum Tuesday [Empty]

This formula is not working perfectly:

IF(AND(A6="",B6=""),"",IF(OR(A6="",B6="",A6="Orange",A6="Mango",A6="Plum",A6="Grape",A6="Pawpaw",A6="Onion"),"",IF(AND(A6="Apple",B6="")," ","Apple")))

Is there a formula that would achieve the desired result?