multiple right/if formula

Occasional Contributor

Can someone help me get over this hurtle?  I have a number that I need to pull the last digit from, depending on that value I need the cell to say a specific(2 words) text. I'm able to use the right command to get the value for one instance but I can't get it to work for multiple different value.  




2 Replies
best response confirmed by werner77 (Occasional Contributor)


=IF(RIGHT(C5,1)="6","6 red",IF(RIGHT(C5,1)="5","5 yellow",IF(RIGHT(C5,1)="4","4 white","")))

Is this what you want to do? 

You would use IFS function since it is easier, since you can use many condition at the same function

=ifs( condition1, True value1, condition2, True value2, ...)

=IFS(RIGHT(AR4,1)="6"," 6 - YE:Yellow",RIGHT(AR4,1)="5","5 - RD: Red")