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

[MZ]

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

 

[Roger Govier]

see replies to your posting in another group

--
Regards
Roger Govier

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

__________ 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

 

[David Biddulph]

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