Subject: Formula for two (or more) "If's"
 

In calculating a formula for deductibles, how would I express the following

There is a $2,400 deductible for each spouse;
if Bob has a claim of over $2,400, then return the amount above 2.4k; if
Bobs claim is 2.4k or lower, then return zero
the same applies to Bernice (only if she also has a claim over 2.4k, then
subtract the deductible); if only one has a claim over 2.4k, then only his
claim less 2.4k is recorded; the others claim of less than 2.4k is zero; if
both have claims above 2.4k, then add their amounts and deduct 4.8k; the
total after all subtractions cannot be below zero
thank you

--
MZ

Subject: Formula for two (or more) "If's"
 

see replies to your posting in another group

--
Regards
Roger Govier

"MZ" wrote in message
...
In calculating a formula for deductibles, how would I express the
following

There is a $2,400 deductible for each spouse;
if Bob has a claim of over $2,400, then return the amount above 2.4k; if
Bobs claim is 2.4k or lower, then return zero
the same applies to Bernice (only if she also has a claim over 2.4k, then
subtract the deductible); if only one has a claim over 2.4k, then only his
claim less 2.4k is recorded; the others claim of less than 2.4k is zero;
if
both have claims above 2.4k, then add their amounts and deduct 4.8k; the
total after all subtractions cannot be below zero
thank you

--
MZ

__________ Information from ESET Smart Security, version of virus
signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Subject: Formula for two (or more) "If's"
 

Have you looked at the answers you got when you asked a similar question
yesterday evening?
--
David Biddulph

"MZ" wrote in message
...
In calculating a formula for deductibles, how would I express the
following

There is a $2,400 deductible for each spouse;
if Bob has a claim of over $2,400, then return the amount above 2.4k; if
Bob's claim is 2.4k or lower, then return zero
the same applies to Bernice (only if she also has a claim over 2.4k, then
subtract the deductible); if only one has a claim over 2.4k, then only his
claim less 2.4k is recorded; the other's claim of less than 2.4k is zero;
if
both have claims above 2.4k, then add their amounts and deduct 4.8k; the
total after all subtractions cannot be below zero
thank you

--
MZ