G Guest Dec 7, 2004 #1 What function can I use/make to figure the difference in percentage between 2 monetary amounts?
H Harald Staff Dec 7, 2004 #2 Hi 40 in A1. 80 in B1. In C1 formula =A1/B1 format as percent numberformat and you may discover that 40 is 50% of 80. HTH. Best wishes Harald
Hi 40 in A1. 80 in B1. In C1 formula =A1/B1 format as percent numberformat and you may discover that 40 is 50% of 80. HTH. Best wishes Harald
B Bernard Liengme Dec 8, 2004 #3 I think OP wants the <difference>: =(B1-A1)/A1 or =B1/A1 - 1 format as percentage
G Guest Dec 8, 2004 #4 I would use the formula =(B1-A1)/abs(A1) where the data in B1 is new and the data in A1 is what you want to compare to. The reference to the absolute value in the denominator insures that the percent change signs are correct if and when a negative number were to occur.
I would use the formula =(B1-A1)/abs(A1) where the data in B1 is new and the data in A1 is what you want to compare to. The reference to the absolute value in the denominator insures that the percent change signs are correct if and when a negative number were to occur.
