ExcelNovice
Well-known Member
- Joined
- May 12, 2002
- Messages
- 583
I'm trying to get a macro that will populate cell C3 with the word "Excellent" if cell B3 is > 1; "Satisfactory" if B3 is > 2.5; "Fair" if B3 is > 3.5; "Moderate" if B3 is > 4.5; "Average" if B3 is > 6 and "Poor" if B3 is > 7.
I know how to do this using IF Statement, but I would prefer to use a macro. Your help will be appreciated.
Thanks.
I know how to do this using IF Statement, but I would prefer to use a macro. Your help will be appreciated.
Thanks.