need help with a formula - % reduction
 

This is my very first post. I am a bit nervous because I am unsure if
I am creating this post correctly. Anyways, I need help on a formula
that will do the following:

Lets say that there are 100 Total Lunch days. As part of the 100 Total
Lunch days, there are 10 Sandwich days.

The Sandwich day rate is currently 10%.

The new target Sandwich day rate is 4.3%.

To match the new target Sandwich day rate, I need to figure out the NEW
Total Lunch days and the NEW Sandwich days.
Sandwich Days/Total Lunch days would be 4.3%.

What formula would I use to do this?
I am using excel.

Thanks.

Are you looking for a formula that will tell you how many days of your total
lunch days should be sandwich days to meet your 4.3% target?

If so, assume that the total days are in A2, then

=A2*4.3%

will give you the answer. But you probably want a whole number of days, so
best to round it,

up , for instance 4.3 goes to 5 as does 4.8, is

=ROUNDUP(A2*4.3%,0)

and down, 4.3 becomes 4 as does 4.8, is

=ROUNDDOWN(A2*4.3%,0)

And welcome to the Microsoft public NGs!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"andy" wrote in message
oups.com...
This is my very first post. I am a bit nervous because I am unsure if
I am creating this post correctly. Anyways, I need help on a formula
that will do the following:

Lets say that there are 100 Total Lunch days. As part of the 100 Total
Lunch days, there are 10 Sandwich days.

The Sandwich day rate is currently 10%.

The new target Sandwich day rate is 4.3%.

To match the new target Sandwich day rate, I need to figure out the NEW
Total Lunch days and the NEW Sandwich days.
Sandwich Days/Total Lunch days would be 4.3%.

What formula would I use to do this?
I am using excel.

Thanks.

Andy,

With total Lunch days in A1, 4.3% in D1,

=A1*D1 will give the new Sandwich days and

=A1*(1-D1) will give the other Lunch days

If you want if in whole days only then

=ROUND(A1*D1,0) will give the Sandwich days and

=ROUND(A1*(1-D1),0) the other days


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"andy" wrote in message
oups.com...
This is my very first post. I am a bit nervous because I am unsure if
I am creating this post correctly. Anyways, I need help on a formula
that will do the following:

Lets say that there are 100 Total Lunch days. As part of the 100 Total
Lunch days, there are 10 Sandwich days.

The Sandwich day rate is currently 10%.

The new target Sandwich day rate is 4.3%.

To match the new target Sandwich day rate, I need to figure out the NEW
Total Lunch days and the NEW Sandwich days.
Sandwich Days/Total Lunch days would be 4.3%.

What formula would I use to do this?
I am using excel.

Thanks.

andy wrote:
This is my very first post. I am a bit nervous because I am unsure if
I am creating this post correctly. Anyways, I need help on a formula
that will do the following:

Lets say that there are 100 Total Lunch days. As part of the 100 Total
Lunch days, there are 10 Sandwich days.

The Sandwich day rate is currently 10%.

The new target Sandwich day rate is 4.3%.

To match the new target Sandwich day rate, I need to figure out the NEW
Total Lunch days and the NEW Sandwich days.
Sandwich Days/Total Lunch days would be 4.3%.

What formula would I use to do this?
I am using excel.

Thanks.

Well you created the post just fine, but I'm a little confused
on what you are trying to do. You need to know either the number
of total lunch days or the number of Sandwich days. You can't solve
for both. Do you know the total lunch days?

gls858