Posted to microsoft.public.excel.misc

external usenet poster

Posts: 19

IF Function not working

I want cell S13 to give a certain answer depending on the value in cell Q13 -
I.E.
IF cell Q13 value is .1 or less then S13 = GOOD IF cell Q13 value is .1
to .2 then cell S13 = FAIR and if cell Q13 value is greater than .2 cell S13
= POOR. Here's the equation I have now and all cell S13 will tell me is #NAME?
=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))
--
Loren

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
Sum function not working, help please!	trickdigger	Excel Worksheet Functions	2	April 9th 06 03:04 AM
IF(AND function is not working	Access Newbie looking for help	Excel Worksheet Functions	4	March 20th 06 06:47 PM
Function not working	donnaK	Excel Worksheet Functions	8	December 8th 05 08:03 PM
Function F3 key not working	wyattran	Excel Worksheet Functions	0	August 8th 05 04:38 PM
IF Function not working	sonicj	Excel Discussion (Misc queries)	2	February 2nd 05 02:00 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us