Formula for comparison

[Futiger7]

Hello,

I am trying to get percentage comparison for monthly sales. Cell A3
has total sales for current month. Cell A35 has total sales for las
year (same month). I need formula in cell B34 with following result -
If sales are less, then display negative sign with percentage number.
If sales are more, then display positive sign with percentage number.
If sales are same, then display text "same".

Thank you.

Best

 

[Kevin H. Stecyk]

Futiger7 wrote

Hello,

I am trying to get percentage comparison for monthly sales. Cell A33
has total sales for current month. Cell A35 has total sales for last
year (same month). I need formula in cell B34 with following result -
If sales are less, then display negative sign with percentage number.
If sales are more, then display positive sign with percentage number.
If sales are same, then display text "same".

Thank you.

Best.

B34=IF(A33/A35-1=0,"Same", A33/A35-1)

Be sure to format B34 as "percentage".

If it were me, I would just show 0% change as 0%, not "Same."
B34=A33/A35-1

Hope that helps.
Kevin

 

[Ron Rosenfeld]

Hello,

I am trying to get percentage comparison for monthly sales. Cell A33
has total sales for current month. Cell A35 has total sales for last
year (same month). I need formula in cell B34 with following result -
If sales are less, then display negative sign with percentage number.
If sales are more, then display positive sign with percentage number.
If sales are same, then display text "same".

Thank you.

Best.


---

You could use the formula:

=(A33/A35)-1

and use the custom format

Format/Cells/Number/Custom Type: +0.0%;-0.0%;"Same"

The actual result in the cell will always be a number, this way.


--ron

 

[Futiger7]

Thank you guys