Posted to microsoft.public.excel.worksheet.functions

Steph

external usenet poster

Posts: 110

My IF in Excel formula is not returning the correct value.

I am doing a reference of 1, 2, or 3 returning specific text based on the
number. Here is my formula.

=IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS")))

if the ratings are all 3's the correct text value will appear. If you vary
the ratings I receive a false value. Can anyone help me.

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
Excel formula Q	scoobz	Excel Worksheet Functions	8	July 17th 06 07:19 AM
Trouble writing an excel formula.	hbb2699	Excel Worksheet Functions	3	June 8th 06 06:36 PM
converting formula from lotus.123 to excel	zaharah	Excel Worksheet Functions	2	July 27th 05 03:04 PM
Problem with VBA returning the contents of a long formula.	[email protected]	Excel Discussion (Misc queries)	2	February 23rd 05 12:14 AM
How do I view the actual numeric value of a formula in Excel 2002.	Excel Function Help	Excel Worksheet Functions	0	January 13th 05 10:07 PM

All times are GMT +1. The time now is 12:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us