LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bill R
 
Posts: n/a
Default Problem with nested logical formula.

Why can't I get the formula below to work? There are 6 sheets in my
worksheet, each of which calculates a payment with different options. The
formula is located on a 7th sheet that is in the same workbook. The formula
should pull the correct payment from the correct sheet based on the options
selected by a customer who will put an "x" in one, or both of two boxes and
choosing either "single" or "joint" life Ins. I have put several hours into
this one formula; any suggestions? Please.

=IF(IF(AND(ISBLANK(BU26),NOT(ISBLANK(BU29)),AH!E19 ),
(IF(AND(NOT(ISBLANK(BU26)),(BX26="Single"),ISBLANK (BU29)),SL2!E19),IF(AND((NOT(ISBLANK(BU26))),(BX26 ="Joint"),ISBLANK(BU29)),JL2!E19),IF(AND((NOT(ISBL ANK(BU26))),(BX26="Single"),NOT(ISBLANK(BU29))),'S L&AH2'!E19),IF(AND(NOT(ISBLANK(BU26)),(BX26="Joint "),NOT(ISBLANK(BU29))),'JL&AH2'!E19),
(IF(AND(ISBLANK(BU26),ISBLANK(BU29)),NONE3!E19)))

Thanks.



 
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
nested formula with if condotion ramana Excel Worksheet Functions 2 September 24th 05 11:01 AM
Interesting Workbook formula problem Bill R Excel Worksheet Functions 3 September 2nd 05 09:04 PM
Problem with formula in Excel Bill R Excel Worksheet Functions 3 August 15th 05 03:02 AM
Precision problem with automated formula fill-in Erny Meyer Excel Worksheet Functions 1 February 4th 05 01:22 PM
ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS Linda Bolton Excel Worksheet Functions 2 January 14th 05 11:58 AM


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

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"