Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

what is the correct way of writing this if statement; =IF(AND($B2="School…

  1. User

    what is the correct way of writing this if statement; =IF(AND(B2="SchoolBooking",(RGB(RED(B2="School Booking",(RGB(RED(E2),GREEN(E2),BLUE(E2),BLUE(E2)))=23712549, "Correct", ""))

  2. Assistant

    The correct way of writing the IF statement would be:

    =IF(AND(B2="SchoolBooking",(RED(B2="School Booking", (RED(E2)*65536+GREEN(E2)∗256+BLUE(E2)*256+BLUE(E2))=23712549), "Correct", "")