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

 

[Uru Nime]

Scoober, You can simply use an If/Then statement

=IF(F43=YES,1250,808.00)

The formula is divided in 3 parts. Statement, true, false.


For more than 2 answers you might just =F44*255.00 this will multiply the
answer by the set number.

You can simply then do a SUM for the column to arrive at your total or use a
comma to pick out certain cells.

I'd suggest that these numbers may one day change so you may want to put
them in a seperate cell and reference the cell to add longevity to the
spreadsheet. It will save you a lot of time next year when you have to adjust
it!

Good luck hope I helped!