If statements

Giganews Newsgroups
Subject: If statements
Posted by:  Mark.M.Sween…@gmail.com (Mark.M.Sween…@gmail.com)
Date: Wed, 9 Jul 2008

I want an IF statement that would be able to do the following:

IF cell A6 is between 1 and 4 then put "A" in cell A7
IF cell A6 is between 5 and 8 then put "B" in cell A7
IF cell A6 is between 9 and 12 then put "C" in cell A7
IF cell A6 is between 13 and 16 then put "D" in cell A7
IF cell A6 is between 17 and 20 then put "E" in cell A7

Any idea how I could do this?

Thank you in advance, Mark

Replies