# Help needed with particular formula. Having a blonde monent!

#### looby

##### New Member
I thought I'd say before I talk about the problem in hand, I'm not looking for anyone to do my assignment for me, just to know the structure of a particular formula.

It's a very basic formula that I need to work out.

-I need to work out the percentage of customers that buy an item of food per day.

-It's fairly easy to work out in your head (500 customers per day, 30% eat food, therefore meaning 150 eat food per day).

-The formula I have at the moment is =(B8/B9)*100 (Which I know is wrong but is the closet I could get to anything feasible).

-I just need to know a formula which would calculate 30% of 500. I know it's something very simple, such as a particular function I need to use but I really can't find anything of use.

Any help is very much appreciated!

Louis

P.S I am using the XP version of Excel if it helps. Thanks again

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Yogi Anand

##### MrExcel MVP
Hi Louis:

Welcome to MrExcel Board!

Let us look at it this way ...

what would be 1/2 of 500 ... =500*(1/2)

now we know 30% is =30/100

so now if we want to know what is 30% of 500, our formula would be ...

=500*(30/100)

EXCEL has a percent formulation built in ... so we can also obtain 30% of 500 using the following formula ...

=500*30%

#### looby

##### New Member
Thanks very much Yogi. Christ it really was that simple! :wink:

Thanks again!

Replies
2
Views
156
Replies
3
Views
204
Replies
4
Views
370
Replies
6
Views
347
Replies
2
Views
175

1,195,952
Messages
6,012,509
Members
441,703
Latest member
clivelincoln

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back