Formula for two "If's"

  • Thread starter Thread starter MZ
  • Start date Start date
M

MZ

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

There is a $2,400 deductible for each spouse; That is, if Bob has a claim of
over $2,400, then return only the amount above 2.4k; if Bernice also has a
claim over 2.4k, then add her amount above 2.4k to Bob's amount; it is
possible for only Bob or only Bernice to have a claim or for both of them to
have claims; anyone whose claim is below 2.4k would not be recorded; the
total after all subtractions cannot be below zero
thank you
 
Back
Top