help with this formula please

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
 
J

John

Hi
IF you want answers separately, I'm using B3 as reply cell, change it to
your needs
F43 =IF(B3="N",808,IF(B3="Y",1250,""))
F44 =IF(B4=1,225,IF(B4=2,450,IF(B4=3,675,"")))
F45 =IF(B5=1,370,IF(B5=2,740,IF(B5=3,1110,"")))
And to Sum everything in Q53 =sum(F43:F45)
HTH
John
P.S. I love your formula Don. I learn something every day
 
S

Scoober

Thank you Don the forula is awesome.

Don Guillett said:
=if(f43="yes",1250,808)+(f44*225)+(f45*370)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 
S

Scoober

Thank you for your help john!

John said:
Hi
IF you want answers separately, I'm using B3 as reply cell, change it to
your needs
F43 =IF(B3="N",808,IF(B3="Y",1250,""))
F44 =IF(B4=1,225,IF(B4=2,450,IF(B4=3,675,"")))
F45 =IF(B5=1,370,IF(B5=2,740,IF(B5=3,1110,"")))
And to Sum everything in Q53 =sum(F43:F45)
HTH
John
P.S. I love your formula Don. I learn something every day
 
D

Don Guillett

It could be a bit better
=if(f43="yes",1250,if(f43="no",808,0))+(f44*225)+(f45*370)
 

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

Similar Threads


Top