Hello.

I have a column (Lets say column G) with data that has a number in ranging from 0 up.

I need a formula that will give me the results

if cell in column G is 0 - 74 then it gives me the result RUN RATE.
if cell in column G is 75 - 99 then it gives me the result COMMS.
if cell in column G is 100+ then it gives me the result AGED WIP.

Many Thanks

Nath'