| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with this 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with this formula please
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 "Scoober" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with this formula please
Thank you Don the forula is awesome.
"Don Guillett" wrote: =if(f43="yes",1250,808)+(f44*225)+(f45*370) -- Don Guillett Microsoft MVP Excel SalesAid Software "Scoober" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with this formula please
Thank you for your help john!
"John" wrote: 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 "Scoober" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with this formula please
It could be a bit better =if(f43="yes",1250,if(f43="no",808,0))+(f44*225)+( f45*370) -- Don Guillett Microsoft MVP Excel SalesAid Software "Scoober" wrote in message ... Thank you Don the forula is awesome. "Don Guillett" wrote: =if(f43="yes",1250,808)+(f44*225)+(f45*370) -- Don Guillett Microsoft MVP Excel SalesAid Software "Scoober" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
