I am not sure what the problem is. I am using excel 2003 and its working fine.. can you forward your workbook as attachment.
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
--- On Fri, 14/11/08, jmholt <[EMAIL PROTECTED]> wrote:
From: jmholt <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Nested IF statements
To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com>
Date: Friday, 14 November, 2008, 9:18 PM
I'm trying to figure out nested IF statements. The statement below
works fine except for the last argument:
IF(C7<=542,11,IF(C7<=589,12,L16)).
IF C7=540 then it returns 11.
If C7 = 560 then it returns the value from L16 and not 12.
Any ideas why it is not returning the the TRUE value? Is there a
better method then using nested IF's?
John
Connect with friends all over the world. Get Yahoo! India Messenger at
http://in.messenger.yahoo.com/?wm=n/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
Book1.xls
Description: MS-Excel spreadsheet
