excel advanced - Zero Impact Level using IF Analysis!!

Resolved · Low Priority · Version Standard

Zero Impact Level using IF Analysis!!

Dan has attended:
No courses

by - delegate Dan [3 posts] (2007 Sep 26 Wed, 15:24) Reply

Hi All

Basically what im trying to achieve is a zero impact %.
The way ive set it out is our current charge x transaction levels, which gives me a current revenue per mth (i work in a fast food HQ).
Now i propose to increase the prices by 15pence per item. So what i need to find out is the decline in custom/transactions before my revenue decreases below its original transaction level at the original price.
So far i have 1%, 3%, 5%, 10% and then i can see it goes into a minus figure, but what i need is the exact % as it could be anything in between 5 and 10% (usually as you can obviously see this)

I cant work out an IF Formula that could show this to me. Can you help me please

Regards
Dan

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Zero Impact Level using IF Analysis!!

by - trainer Rich platinum contributer [744 posts] (2007 Oct 2 Tue, 11:31) Reply

Hi Dan,

Not 100% sure on what you're trying to achieve here. Could you type an example of data in columns and then the cell calculation so we can reciprocate here?

You say you want the exact %, couldn't you just set the cell format to include decimal places on the % setting?

Regards, Rich