Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple functions in a cell help
I am using Excel 2003 and having trouble figuring out the formulas. What I am
trying to do is add a total of 6 cells in a row. Each cell has a different formula that comes up with a certain value once all cells are added together. Example: cell A= inserted value*10 cell B= inserted value*2 cell C= inserted value cell D= inserted value*5 cell E= inserted value*3 cell F=inserted value/20 In cell G, I want to add cells a through f except that cell f has multiple "if then" statements. Cell f: if inserted value/20 <10 then I want to add a number to the sum of cells a through e if inserted value/20 is between 11 and 15 I don't want to add a certain number to the sum of cells a through e if inserted value/20 is between 16 and 20 I want to subtract a certain number to the sum of cells a through e Anyhelp on this is greatly appreciated! Hopefully I explained what I want to do without confusing everyone as much as it's confusing to me:) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple functions in a cell help
I am not certain I am interpreting this correctly, but it sounds like you want to have a formula in cell F? and be able to allow a numerical entry into that cell as well. If that is what you are trying to do, it is not possible as far as I know. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple functions in a cell help
Mark,
I actually want the formula in cell g. Cells a through f should actually be an inserted value and NOT inserted value with the math (that should be part of the formula for cell g). Cell g should have some type of formula (without any inserted values) that will function something like the following: (inserted value of cell a*10) + (inserted value of cell b*2) + (inserted value of cell c) + (inserted value of cell d*5) + (inserted value of cell e*3) + (if (inserted value of cell f/20) < =10 then add 5 OR if (inserted value of cell f/20) = 11 but <=20 then don't add anything OR if (inserted value of cell f/20 =21 but <= 30 then subtract 5) Hopefully this clears it up more. If not, I'll keep trying to explain in a better way of what I'm looking for. Thanks for the help! Mike |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple functions in a cell help
Mikjall777 wrote: Mark, I actually want the formula in cell g. Cells a through f should actually be an inserted value and NOT inserted value with the math (that should be part of the formula for cell g). Cell g should have some type of formula (without any inserted values) that will function something like the following: (inserted value of cell a*10) + (inserted value of cell b*2) + (inserted value of cell c) + (inserted value of cell d*5) + (inserted value of cell e*3) + (if (inserted value of cell f/20) < =10 then add 5 OR if (inserted value of cell f/20) = 11 but <=20 then don't add anything OR if (inserted value of cell f/20 =21 but <= 30 then subtract 5) That makes much more sense, here goes... Assuming that your data resides in Cells A1:F1 Enter the following formula into G1: =SUM(A1*10,B1*2,C1,D1*5,E1*3)+IF(F1/20<=10,F1+5,IF(AND(F1/20=11,F1/20<=20),F1,IF(AND(F1/20=21,F1/20<=30),F1-5,F1))) I hope that works as I doubt you are going to reply tonight and it will be some time before I am on the net again. Best wishes.... |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple functions in a cell help
(inserted value of cell a*10) + (inserted value of cell b*2) + (inserted value of cell c) + (inserted value of cell d*5) + (inserted value of cell e*3) + (if (inserted value of cell f/20) < =10 then add 5 OR if (inserted value of cell f/20) = 11 but <=20 then don't add anything OR if (inserted value of cell f/20 =21 but <= 30 then subtract 5) That makes much more sense, here goes... Assuming that your data resides in Cells A1:F1 Enter the following formula into G1: =SUM(A1*10,B1*2,C1,D1*5,E1*3)+IF(F1/20<=10,F1+5,IF(AND(F1/20=11,F1/20<=20),F1,IF(AND(F1/20=21,F1/20<=30),F1-5,F1))) I hope that works as I doubt you are going to reply tonight and it will be some time before I am on the net again. Best wishes.... |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple functions in a cell help
Mark,
Thank you for the help! That was almost what I was looking for but with your help, I was able to fine tune it exactly. Thanks again! Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MUltiple functions on a same cell | Excel Discussion (Misc queries) | |||
Multiple Formulas in same cell | Excel Worksheet Functions | |||
Multiple Formlas in same cell | Excel Discussion (Misc queries) | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |