Can I get help with this formula please.

[Scoober]

I am trying to produce a spreadsheet that will calculate certain expenses to
help highlight the cost of living.

If someone could help with the following example:

Question 1: Is this a joint application Y/N ? - answer in box F43

So if the answer is 'N' then a figure of $808.00 is added

If the answer is 'Y' then a figure of $1,250.00 is added


Question2: How many dependants do you have? - answer in box F44

if 1 then $225.00 is added
if 2 then $225.00 x 2 is added
if 3 then $225.00 x 3 is added etc

Question 3: How many cars do you own? - answer in F45

if 1 then 370.00 is added
if 2 then 370.00 x 2 is added
if 3 then 370.00 x 3 is added etc

I then want to populate Q53 with the combined total of the answers given
above.

Thank you in advance for any help given.

Cheers Scott

 

[SeanC UK]

Hi Scoober,

Type this formula into your cell, it should do the trick. It adds 808 for N,
1250 for Y and 0 for anything else, 225 * dependants, unless the value is not
from 1 to 3, and likewise for the cars. Other values should result in 0.

=SUM(IF(F43="Y",1250,IF(F43="N",808,0)),IF(AND(F44>0,F44<4),F44*225,0),IF(AND(F45>0,F45<4),F45*370,0))

I hope this helps.

Sean.