Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for two "If's" | Excel Discussion (Misc queries) | |||
Subject: how to convert 112" to 9'4" with a formula in Excel | Excel Worksheet Functions | |||
Formula for Multiple "IF's" or maybe "COUNTIF's"??? | Excel Discussion (Misc queries) | |||
Is it possible to apply IF's to "operator" result.. | Excel Discussion (Misc queries) | |||
textbox value to be used as a "subject" line within an email | Excel Worksheet Functions |