DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate - View Single Post

**addyta.org** · 03-27-2007, 04:57 PM

No - I need to know the percentage margin between the two numbers. I don't know how better to explain it to be honest I don't need to know how much bigger one number is that the other, its the difference (margin) expressed as a percentage that I am interested in.

If its any help - using another spreadsheet I have here, I get a percentage margin of 40%, when I use those two numbers (45 and 75). Trouble is that spreadsheet is written in such a way that I cannot just lift out the formula to use in the other document I am creating.

It won't work without a "fudge factor", the previous poster was correct, as you can't get those values to work without one.
Can you give another example, prefereably a couple, do check the fudging is a fixed or variable factor?
Alternatively - and preferably - can you check with the person who initially prepared the spreadsheet?

To be consistent, though, you may have to accept that there may be a negative value if things went down -you may be able to set it to give an absolute (?) number that won't have a negative value, regardless.

03-27-2007, 04:57 PM	#5
addyta.org Join Date Oct 2005 Posts 557 Senior Member	No - I need to know the percentage margin between the two numbers. I don't know how better to explain it to be honest I don't need to know how much bigger one number is that the other, its the difference (margin) expressed as a percentage that I am interested in. If its any help - using another spreadsheet I have here, I get a percentage margin of 40%, when I use those two numbers (45 and 75). Trouble is that spreadsheet is written in such a way that I cannot just lift out the formula to use in the other document I am creating. It won't work without a "fudge factor", the previous poster was correct, as you can't get those values to work without one. Can you give another example, prefereably a couple, do check the fudging is a fixed or variable factor? Alternatively - and preferably - can you check with the person who initially prepared the spreadsheet? To be consistent, though, you may have to accept that there may be a negative value if things went down -you may be able to set it to give an absolute (?) number that won't have a negative value, regardless.
	Quote