# Excel formula

#### ahamed85

##### New Member
HELLO,

 Promotion Promo.price Regular Price sold qty sold price Promo price sold qty Regular price Qty 1+1 5 4 11 29 ? ?

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

### 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).
Hi!
what do you mean by 1+1 ?
Can you give us more details about the input values and computation needed ?

Last edited:
Hi
if buy 2 qty. price is \$5.
if buy 3 qty. promo price is \$5 for 2 qty, remaining 1 qty is \$4, total amount \$9.

Excel 2010
ABCDEFG
1PromotionPromo.priceRegular Pricesold qtySalePromo price sold qtyRegular price Qty
21+1541129101
3543921
1d
Cell Formulas
RangeFormula
E2=INT(D2/2)*B2+MOD(D2,2)*C2
E3=INT(D3/2)*B3+MOD(D3,2)*C3
F2=INT(D2/2)*2
F3=INT(D3/2)*2
G2=D2-F2
G3=D3-F3

Replies
9
Views
2K
Replies
2
Views
346
Replies
7
Views
913
Replies
0
Views
507
Replies
4
Views
267

1,196,134
Messages
6,013,642
Members
441,777
Latest member

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