ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I need help with a formula please. (https://www.excelbanter.com/excel-programming/423758-i-need-help-formula-please.html)

Scoober

I need help with a formula please.
 
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



All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com