Nested if

[Curtis]

I have a row which contains various text and need a formaula to rename the
text to smaller groups

If it equals "filters" then "non fuel"
if it equals "oil", then "fuel"

This information will be tallied in a cell in the same spreadsheet running
the length of the sheet say cell z3 through z6000

thanks

 

[Don Guillett]

Use EDIT>replace

 

[John Calder]

Assuming text is in cell A1

=IF(A1="FILTERS","FUEL",IF(A1="OIL","NON-FUEL"))

 

[Curtis]

a little more help please

=IF(T3="Heavy Duty & Equipment Customers",IF(T3="Retail
Customers","Commercial","Retail NON-Gas"))

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.