Hi,

I need a forumla for the following please.

I have a range of values in column A

I need a forumla that says,

If value in column A is between 1-100, then fill in the cell with the letter A, If the value in col A is between 101-200, then fill the cell with B and so on until I get to W.

any help would be seriously appreciated.

Thanks