Excel "IF" Statement

[Montano]

Can you do an "IF Statement" with two criteria? Example:

If I have two numbers and I am trying to get a percentage of growth, how can I write the formula so that it works whether both numbers are positive, both numbers are negative, or one is negative and one is positive?

Thanks for your help!

 

[Wray69]

use the ABS function and that will make your numbers absolute... if that doesnt help give more information and Im sure I can help you...

Regards -
Wray

 

[Montano]

Here's an example:

Curr YR (370)
Prior YR (968)

How can you write the formula to get the correct % growth?

 

[meintsi]

If I understand what you are asking for,
isn't the % growth just:

Curr YR = cell A1
Prior YR = cell B1

=(A1-B1)*100/ABS(B1) *Remember.......
If you don't use your head,
your going to have to use your feet.