Forum Discussion
Solved
multiple right/if formula
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 ...
=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?
=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?