mardi 10 décembre 2019

Regematch if, and, and date combined forumula

I need help trying to figure out a combination google sheets formula

If 
    Cell B5 contains "Rct"
And
    today's date is 30 days after the date defined in cell C5
And
    if Cell D5 and D6 both says "2 weeks ago" or "1 week ago" or contains the words "day" "hour" or "minute"

(not sure if possible but instead of the all those words could if be if the text in cell D5 and D6 are the color "green" and or "Yellow")

Then
    Cell H5 will say "Y" if the above conditions are met or "N" if they aren't

Picture of my google sheet

Aucun commentaire:

Enregistrer un commentaire