Help on IF function - ExcelBanter

Posted to microsoft.public.excel.worksheet.functions

CBZ[_2_]

external usenet poster

Posts: 10

Help on IF function

I seem to not be able to figure out the following formula. I am trying to
have the formula give back ascribed #'s per text value, if no text =0. Can
anyone help.
=IF(Q="Disastrous",1,(IF(Q="Unacceptable",2,(IF(Q= "Undesirable",3,(IF(Q="Neutral",4,(IF(Q="Acceptabl e",5,(IF(Q="Preferred",6)))))))))))

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
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook)	[email protected]	Excel Worksheet Functions	0	September 5th 06 03:44 PM
Offset function with nested match function not finding host ss.	MKunert	Excel Worksheet Functions	1	March 21st 06 10:46 PM
Datevlaue function/ day/month/year function	Nav	Excel Worksheet Functions	7	January 23rd 06 02:31 PM
Emulate Index/Match combo function w/ VBA custom function	Spencer Hutton	Excel Worksheet Functions	2	May 2nd 05 05:26 PM
Nested IF Function, Date Comparing, and NetworkDays Function	carl	Excel Worksheet Functions	2	December 29th 04 09:57 PM

All times are GMT +1. The time now is 11:39 AM.

Menu

About Us