In excel I have financial data that has "account number" (ex. 1000, 1001, etc) in column 1, "account description" (cash, a/r) in column 2 and the account balance (8,794) in column 3.

Basically I want to know how I can construct an IF statement in VBA that says IF the value in column 1 is greater than 1000 but less than 1005 THEN assign it a value of "cash" in column 4 for all of the account numbers within this range.

Any input would be greatly appreciated!

attached is the project and also how I need the spreadsheet to look like
IDS 331 Project (2).xlsm

http://i.imgur.com/zM1vhE9.png