Help thx

[Tacks]

I have about 5 days worth of work that a supervisor wants done today. I needs a quick conversion website where I can plug numbers into to find out percentage of increase and decrease in price cost without having to do the conversions myself. Anyone know where I can do this?

[labbats]

I don't understand what you're asking. Do you want to simply put in two numbers and find the percentage of difference between them?

[kaharthemad]

if thats what you want I would suggest writing a quick excel code for it. I most likely can puzzle one out for you.

[Tacks]

I don't understand what you're asking. Do you want to simply put in two numbers and find the percentage of difference between them?

Yes, the only problem is that they are not all increases so one formula will not work for all of them. So basically I would need a plug-in formula for % of increase and one for % of decrease.

It's been years since I've done excel code as well >< I can try anything you think will help. Thanks.

[Zanchief]

You could do that in 2 seconds with excel

[labbats]

I can't do excel to save my life. Good luck Taxx.

[Tacks]

I can't do excel to save my life. Good luck Taxx.

same

This is my problem Zan

[Ganzo]

there is formula in excel for that i use it when i do accounting, but i can't remeber what it is, if you can wait till tomorow i got it at work

[kaharthemad]

ill see if I can puyll it out of my past programs. give me a few taxx

[Zanchief]

=IF(A1>B1,A1/B1*100-100,B1/A1*100-100)

A1 is one number B1 is another.

That wont tell you if it's increasing or decreasig though it will just give you a percent that one number differs from another.

That good enough?

[Menlaan]

Try this:
For percentage increase from cell B1 to cell A1: =IF(A1>=B1,(A1-B1)/B1,"")
For percentage decrease from cell B1 to cell A1: =IF(A1<B1,-(A1-B1)/B1,"")
If you want something other than blanks for where it doesn't matter, you can substitute the "" with a 0.

Is this what you're looking for?

Menlaan

[Ganzo]

nm Menlaan posted one i use

[Zanchief]

=IF(A1>B1,"Decrease","Increase")

stick that in the cells next to the other formula that will at least tell you if it increases or decreases.

Just drag down the formula and you could cover as many sets of numbers as you want.

[kaharthemad]

Assume 100 is in A2 and 150 is in B2, in C2 put in


=(B2-A2)/A2


Format the cell as percentage.


If you want words as you show


=IF(B2>A2,TEXT((B2-A2)/A2,"0% ")&" Increase",IF(B2<A2,TEXT((B2-A2­)/A2,"0%
")&" Decrease","No Change"))


But a negative sign and "decrease" create a double negative. If you want 6%
decrease, change the formula to (A2-B2)/A2 in the second case.
its a bit unwieldy but that might do it for you.

[kaharthemad]

bah slow on the uptake but yeah
same one i used on mine. I just had to look the formual back up

[Menlaan]

Yep. Either of those will work fine. If you format my column as a percent you'll get the same numbers as Zanchief's. It really is up to personal preference. Let us know if you needed something different. I'll check back in an hour or so.

Menlaan

[kaharthemad]

same here BTW Menlaan im taking the valve stems out of your tires for posting before me.

[Tacks]

Ok looks like this is working, thanks guys.

Just to make sure I have this correct. Here's an example I have.

Old price is $1.50 (column A) New Price is $1.40 (column B)

[Tacks]

Hmm I guess increases won't work the way it's set up but 99% of these are decreases (we switched to a new vendor).

[Zanchief]

what happens if A1 is smaller and B1?

[Tacks]

It leaves a blank

[Zanchief]

yea I was pointing it out for you. Seems like you pretty much have it.

[Tacks]

Thanks everyone

[Menlaan]

If you want it to work for increases, replace the "" with -(A1-B1)/B1

Sorry I haven't been able to check back before now.

Menlaan

[Menlaan]

same here BTW Menlaan im taking the valve stems out of your tires for posting before me.

I just saw this. I think I'm safe, though. I don't have a car!

Menlaan