Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formulas
Hello!
I am using Excel 2003 and I need to be able to write a conditional formula to perform two different sets of functions depending on the value of one of my cells. For instance, if this particular cell has a value of 30, I the function to begin computing cost savings in the following month. If it is equal to 60, I need the fundtion to begin computing the cost savings starting two months out. Is there a way to get Excel to do this? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formulas
=IF(A2=30,cost savings formula 1 month out,if(A2=60,cost savings formula 2
months out)) "HZC" wrote: Hello! I am using Excel 2003 and I need to be able to write a conditional formula to perform two different sets of functions depending on the value of one of my cells. For instance, if this particular cell has a value of 30, I the function to begin computing cost savings in the following month. If it is equal to 60, I need the fundtion to begin computing the cost savings starting two months out. Is there a way to get Excel to do this? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formulas
Hi,
You should really show us your cost savings formulas so we know what we are playing with. In lieu of that =IF(A1=30,formula1,formula2) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "HZC" wrote: Hello! I am using Excel 2003 and I need to be able to write a conditional formula to perform two different sets of functions depending on the value of one of my cells. For instance, if this particular cell has a value of 30, I the function to begin computing cost savings in the following month. If it is equal to 60, I need the fundtion to begin computing the cost savings starting two months out. Is there a way to get Excel to do this? Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formulas
Thanks for the input! It worked fine. You saved a lot of people a lot of
hassles ! :) HZC "Shane Devenshire" wrote: Hi, You should really show us your cost savings formulas so we know what we are playing with. In lieu of that =IF(A1=30,formula1,formula2) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "HZC" wrote: Hello! I am using Excel 2003 and I need to be able to write a conditional formula to perform two different sets of functions depending on the value of one of my cells. For instance, if this particular cell has a value of 30, I the function to begin computing cost savings in the following month. If it is equal to 60, I need the fundtion to begin computing the cost savings starting two months out. Is there a way to get Excel to do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formulas | Excel Discussion (Misc queries) | |||
conditional formulas | New Users to Excel | |||
conditional formulas | Excel Worksheet Functions | |||
Conditional formulas with sum and if | Excel Discussion (Misc queries) | |||
conditional formulas | Excel Worksheet Functions |