LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Nested IF Formula Evaluation Pls


Hi everyone,

I may have discovered a way to solve my own question in a previous post
(http://www.excelforum.com/showthread.php?t=528208). I'm attempting to
use a nested IF formula as shown below:

=IF(B9=shifts!A1:A17,"8",IF(B9=shifts!A19:A35,"6", "OFF"))

B9 is a dropmenu of listed shifts (not available shifts) from another
worksheet within the same workbook, titled "shifts". From the
"shifts" worksheet, cells A1 through A17 are 8 hour shifts, while A19
through A35 are 6 hour shifts. I'm attempting to create a formula in
D9 (the hours column), which will automatically fill in 8, 6, or OFF,
depending upon the selection from the dropdown menu in B9.

I *almost* succeeded with a normal IF formula (where *8 was true &
everything else false). Then I realized nesting would probably be
better, since I didn't want any hours sitting in D during an employee's
day off :) Any help would be *VERY* much appreciated. Thanx in
advance...

Big M ;)


--
Big M
------------------------------------------------------------------------
Big M's Profile: http://www.excelforum.com/member.php...o&userid=32994
View this thread: http://www.excelforum.com/showthread...hreadid=528401

 
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
Formula evaluation Edward New Users to Excel 2 March 31st 09 01:31 PM
VLOOKUP FORMULA EVALUATION NEEDED SSJ New Users to Excel 3 March 29th 08 04:15 PM
IF formula - evaluation shows it should work but... Juliet Excel Worksheet Functions 6 January 17th 06 10:39 PM
evaluation of a cell with a formula Daniel[_4_] Excel Programming 3 December 27th 03 08:59 AM


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

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

About Us

"It's about Microsoft Excel"