O Old Red One Sep 12, 2003 #1 How is the formula for percent change between two numbers constructed and entered?
A Alan Sep 12, 2003 #2 Old Red One said: How is the formula for percent change between two numbers constructed and entered? Click to expand... Hi Red, This will calculate the percentage increase from 30 to 45 (50% increase): =(45-30)/30 = 50% This will calculate the percentage decrease from 45 to 30 (33.3% decrease): =(30-45)/45 = -33.3% HTH, Alan.
Old Red One said: How is the formula for percent change between two numbers constructed and entered? Click to expand... Hi Red, This will calculate the percentage increase from 30 to 45 (50% increase): =(45-30)/30 = 50% This will calculate the percentage decrease from 45 to 30 (33.3% decrease): =(30-45)/45 = -33.3% HTH, Alan.
