S
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
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