IF Function

[Safi23]

If C8 shows 'Red' for example and C9 shows 'Blue' how would I make C10 say 'Purple' ? and then change depending on the word combinations?

[#2]

@Safi23 

See https://techcommunity.microsoft.com/t5/excel/if-function/m-p/2159258