I am trying to use check blocks to choose between values that are calculated
on four different sheets within the workbook.
If "BU25" is checked it means the person wants credit life insurance.
If "BU25" is the only block checked then He wants single credit life.
If "BU25" and "CK24" are both checked then He wants joint credit life.
If "BU25", and "BU28" are checked then He wants single credit life and
disability insurance. (The disability Insurance will need a separate formula
that I will work on once this formula is established) however the single
credit life is higher when purchased with disability insurance so the formuls
has to know if it is being purchased or not).
If "BU25", "CK24" and "BU25" are all checked then the customer wants both
joint credit life and disability insurance.
Thanks for your help. I'm not sure that I'm even trying to use the right
formula.
Here is what I have done so far but it does not work:
=IF(ISBLANK(BU25),"",'SL 2'!E24)((IF(ISBLANK(BU28),(IF(ISBLANK(CK24),'SL
2'!E24,'JL 2'!E24))),(IF(ISBLANK(CK24),'SL&AH 2'!E24,'JL&AH 2'!E24))))
"Blue Hornet" wrote:
I don't really see where you're trying to go with this, Bill. What's
the relationship between BU25 and CK24? Where does BU28 fit in to all
of that?
The first paragraph of the scenario is simple enough, and handled
(apparently) by the first IF function.
From the second paragraph I'm thinking you want something like:
=IF( ISBLANK( BU25), "", IF( ISBLANK( CK24), SL!E24, JL!E24))
But then you threw in the IF regarding BU28, and I'm lost.
"Bob Phillips" wrote:
Exactly the point I made in one of his previous threads on the same
question.
--
HTH
Bob Phillips
"Blue Hornet" wrote in message
oups.com...
I don't really see where you're trying to go with this, Bill. What's
the relationship between BU25 and CK24? Where does BU28 fit in to all
of that?
The first paragraph of the scenario is simple enough, and handled
(apparently) by the first IF function.
From the second paragraph I'm thinking you want something like:
=IF( ISBLANK( BU25), "", IF( ISBLANK( CK24), SL!E24, JL!E24))
But then you threw in the IF regarding BU28, and I'm lost.
I think you need to re-state your problem more clearly. What are all
of the conditions you want to check for, and what are the results you
want?
(It would help a lot to get out of the double-letter columns for
purposes of illustration; I'm confused by the multiplicity of letters,
alternate rows, etc. I'll try to deal with it, but it is a pain.)
Chris
|