Formula for two "If's"

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
 
F

Fred Smith

If Bob is in A1, and Bernice is in A2,
=max(0,a1-2400)+max(0,a2-2400)

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top