Automatically change text in cell based upon a rule

Hi All,
I have a spreadsheet which takes imported data from a Business Objects output file. data is the status of a report and all data is in a single column

What I would like to do is to change the text of the report status in certain cases but not in others.
e.g
Where status is "proposed" leave as it is
Where status is either "conduct", "agree draft", Draft report issued" or "Management Review" then change to "in progress"
Where status is "Follow-up Complete" change to Complete
Where status is "complete" leave as it is

Is this possible? I tried using nested IF statements but got myself in a mess.

Thanks for any guidance and help you may offer - I am quite new at this

B

Originally Posted by DonkeyOte

Are you doing this in VBA or Worksheet Functions ?

I was trying it as a worksheet function but only because I have no idea about VBA.

Happy to do it whichever way works

Originally Posted by DonkeyOte

OK that's fine - the fact the Q was posted in the Programming Forum made me question that's all -

Oops - sorry.

As for the code - awesome - I even managed to extend it to include some status levels I didnt tell you about, so thanks very much.