LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default Won't give correct answer

=IF(Q13="","",IF(Q13<0.1,(good),IF(Q130.1<0.2,(FA IR),(POOR))))

Cell Q13 = .33 but what shows up in this cell is #NAME? What am
I doing wrong?
--
Loren
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Finding Correct Answer caldog Excel Worksheet Functions 0 November 25th 06 07:58 PM
Not getting the correct averages. lana1916 Excel Discussion (Misc queries) 2 January 6th 06 04:12 PM
how do i get my spreadsheet to give me tank gage amounts. tankerman Excel Worksheet Functions 3 January 5th 06 04:35 PM
Formula correct, answer wrong TJAC Excel Discussion (Misc queries) 2 January 3rd 06 06:15 PM
How can I turn auto correct on or off for one column only? jacskier Excel Worksheet Functions 3 June 13th 05 04:55 PM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"