# Formula or Macro to calculate No of Stamps

#### AliCat

##### Board Regular
I have arranged a table in excel which has the numbers 1 to 20 in column "B" starting in "B3". In "C3" to "H3" I've entered the value of some postage stamps say 65p, 45p, 25p, 5p, 2p & 1p. I've completed the table by means of formulas to tell me the value of multiple stamps by reference to the quantities shown in column "B". This allows me to look at the table and calculate the number of stamps I need to put on various packages.

I would like to take this a step further to get some automation in my calculation. I would like say, to enter the value of the postage in "B1" and have some formula or function or possibly a macro calculate and the number of the different values of stamps and enter these quantities in cells "C1" to "H1" respectively.

Can any one help.

Thanks, Alison.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Enter in cells C1:H1 the numbers 65,45,25,5,2,1

Enter your postage value in B2 (enter in pounds, e.g. 0.76 representing 76p)

Enter in in C2 the formula =INT(\$B2*100/\$C\$1)

Enter in in D2 the formula =INT(((\$B2*100)-SUMPRODUCT((\$C2:C2)*(\$C\$1:C\$1)))/D\$1)

Drag the D2 formula across to H2

The formulas in C2:H2 can be dragged down

Replies
1
Views
176
Replies
3
Views
227
Replies
1
Views
135
Replies
3
Views
57
Replies
12
Views
572

1,203,514
Messages
6,055,842
Members
444,828
Latest member
StaffordStag

### 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.

### Which adblocker are you using?

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

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