Posted to microsoft.public.excel.worksheet.functions

Curtis

external usenet poster

Posts: 181

Nested if

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
nested if help	Jeremy	Excel Discussion (Misc queries)	4	January 6th 09 04:41 PM
Nested if help....	[email protected]	Excel Worksheet Functions	8	October 17th 07 09:09 AM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
Nested IF	Secret Squirrel	Excel Discussion (Misc queries)	2	December 1st 06 12:02 PM
using nested OR	stef	Excel Worksheet Functions	18	November 3rd 06 09:35 PM

All times are GMT +1. The time now is 10:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us