Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a formula based on another cell value
I am trying to use a different formula based on the value of cell.
So if the the cell value is "Store" use A1+B1+C1 If the cell value is "HQ" use A1+C1+F1 I know I can make a nice long IF formula (I actually need 3 different ones), but can I put a formulas in other cells and refer to a different one in based on the cell values? Or any other creative idea is welcomed. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a formula based on another cell value
Well, if it's only 3, may just be easier to put into one IF.
But, you can put =A1+B1+C1 into, say, A3 Then =A1+C1+F1 into B3 Then your 3rd formula in C3. So: =IF(Cell="Store",A3,if(Cell="HQ",B3,C3)) just creates a reference to the formulas. "SmartBlond" wrote: I am trying to use a different formula based on the value of cell. So if the the cell value is "Store" use A1+B1+C1 If the cell value is "HQ" use A1+C1+F1 I know I can make a nice long IF formula (I actually need 3 different ones), but can I put a formulas in other cells and refer to a different one in based on the cell values? Or any other creative idea is welcomed. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a formula based on another cell value
My fault, I made it sound less complex.
I have 8 quarters of info and will be using sumif in the formulas as well. So I was trying to put the formula in once for each (so 24 total) and not have all of the possible calcs for each row. May not be possible as the dynamic nature of moving to a new row would prevent it from using the right rows of data. Thank you however. Appreciate the response! "Sean Timmons" wrote: Well, if it's only 3, may just be easier to put into one IF. But, you can put =A1+B1+C1 into, say, A3 Then =A1+C1+F1 into B3 Then your 3rd formula in C3. So: =IF(Cell="Store",A3,if(Cell="HQ",B3,C3)) just creates a reference to the formulas. "SmartBlond" wrote: I am trying to use a different formula based on the value of cell. So if the the cell value is "Store" use A1+B1+C1 If the cell value is "HQ" use A1+C1+F1 I know I can make a nice long IF formula (I actually need 3 different ones), but can I put a formulas in other cells and refer to a different one in based on the cell values? Or any other creative idea is welcomed. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a formula based on another cell value
well, depending on the values available, you can use a sumproduct to sum
based on multiple criteria. =SUMPRODUCT(--(A2:A1000=quarter1 start date),--(A2:A1000<=quarter1 end date),sum range) But, not sure exactly what the goal is, so I'll leave it open ended there... "SmartBlond" wrote: My fault, I made it sound less complex. I have 8 quarters of info and will be using sumif in the formulas as well. So I was trying to put the formula in once for each (so 24 total) and not have all of the possible calcs for each row. May not be possible as the dynamic nature of moving to a new row would prevent it from using the right rows of data. Thank you however. Appreciate the response! "Sean Timmons" wrote: Well, if it's only 3, may just be easier to put into one IF. But, you can put =A1+B1+C1 into, say, A3 Then =A1+C1+F1 into B3 Then your 3rd formula in C3. So: =IF(Cell="Store",A3,if(Cell="HQ",B3,C3)) just creates a reference to the formulas. "SmartBlond" wrote: I am trying to use a different formula based on the value of cell. So if the the cell value is "Store" use A1+B1+C1 If the cell value is "HQ" use A1+C1+F1 I know I can make a nice long IF formula (I actually need 3 different ones), but can I put a formulas in other cells and refer to a different one in based on the cell values? Or any other creative idea is welcomed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
Change formula based upon value of a different cell | Excel Worksheet Functions | |||
How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Change cell in formula based on date | Excel Discussion (Misc queries) |