=IF(OR(C1=601,C1=609,C1=623,C1=31),"fees","")
--
Gary''s Student - gsnu200843


"Chiccada" wrote:

Hi all,

I am currently tring to create a Macro Which populates any cell in Column
B based on what is entered in the adjacent cell in Column C. For example, if
I enter any one of 601, 609, 623 or 631 in Column C, the cell next to it in
Column B returns the word "Fees". Any other number returns nothing.

Thanks in advance for your help.

Regards