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!

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!

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!

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!