Hi,
I want to set up a formula where a given number in cell A1 between 1-20 will come up with text A if the given number is 1-9, text B if it is between 10 and 14 and text C if it is above 15 (ie. 15-20). I would want this text to appear in cell A2 as the original given number would still need to be visible.
I hope I've explained that well as I haven't put it into context of my spreadsheet but that would just complicate things further.
Any help would be appreciated.
Cheers.
Bookmarks