Help thx

Tacks · Post by **Tacks** » Wed Jul 27, 2005 7:18 am

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 · Post by **labbats** » Wed Jul 27, 2005 7:26 am

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 · Post by **kaharthemad** » Wed Jul 27, 2005 7:28 am

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 · Post by **Tacks** » Wed Jul 27, 2005 7:30 am

labbats wrote: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 · Post by **Zanchief** » Wed Jul 27, 2005 7:36 am

You could do that in 2 seconds with excel

labbats · Post by **labbats** » Wed Jul 27, 2005 7:39 am

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

Tacks · Post by **Tacks** » Wed Jul 27, 2005 7:40 am

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

same

This is my problem Zan

Post by **Ganzo** » Wed Jul 27, 2005 7:41 am

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 · Post by **kaharthemad** » Wed Jul 27, 2005 7:45 am

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

Zanchief · Post by **Zanchief** » Wed Jul 27, 2005 7:48 am

=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 · Post by **Menlaan** » Wed Jul 27, 2005 7:48 am

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

Post by **Ganzo** » Wed Jul 27, 2005 7:49 am

nm Menlaan posted one i use

Zanchief · Post by **Zanchief** » Wed Jul 27, 2005 7:53 am

=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 · Post by **kaharthemad** » Wed Jul 27, 2005 7:56 am

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 · Post by **kaharthemad** » Wed Jul 27, 2005 7:57 am

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

Menlaan · Post by **Menlaan** » Wed Jul 27, 2005 7:57 am

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 · Post by **kaharthemad** » Wed Jul 27, 2005 7:58 am

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

Tacks · Post by **Tacks** » Wed Jul 27, 2005 8:16 am

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 · Post by **Tacks** » Wed Jul 27, 2005 8:21 am

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 · Post by **Zanchief** » Wed Jul 27, 2005 8:23 am

what happens if A1 is smaller and B1?

Tacks · Post by **Tacks** » Wed Jul 27, 2005 8:24 am

It leaves a blank

Zanchief · Post by **Zanchief** » Wed Jul 27, 2005 8:26 am

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

Tacks · Post by **Tacks** » Wed Jul 27, 2005 8:27 am

Thanks everyone

Menlaan · Post by **Menlaan** » Wed Jul 27, 2005 3:19 pm

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 · Post by **Menlaan** » Wed Jul 27, 2005 4:09 pm

kaharthemad wrote: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! :lol:

Menlaan