Nested if

  • Thread starter Thread starter Curtis
  • Start date Start date
C

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
 
a little more help please

=IF(T3="Heavy Duty & Equipment Customers",IF(T3="Retail
Customers","Commercial","Retail NON-Gas"))
 
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.
 
Back
Top