formula for round then multiply AND formula for if number is bigger than x, multiply by

johnandbeth

Board Regular
I need two formulas.
1) I have applied ROUND to a cell. I then want to multiply the rounded value by another cell. Currently, it multiplies by the actual number, not the rounded value. How do I multiply the rounded value?
2) I want a formula for if the number in this cell is greater than x, multiply by a, if the cell is less than x, multiply by b.

Thanks for the help,
~Beth

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
I need two formulas.
1) I have applied ROUND to a cell. I then want to multiply the rounded value by another cell. Currently, it multiplies by the actual number, not the rounded value. How do I multiply the rounded value?
2) I want a formula for if the number in this cell is greater than x, multiply by a, if the cell is less than x, multiply by b.

Thanks for the help,
~Beth

Hello Beth,

can you identify each cells location. . . for common reference

For the first formula example,
Cell B2 is rounded up, B3 is multiplier, B4 contains formula to multiply B2 x B3. I want to multiply the rounded up value, not the actual cell value from B2.

For the second formula example,
Cell C2 is number, in C3 I want a formula, if C2 is less than x, multiply by "a," or if C2 is greater than x, multiply by "b."

Replies
3
Views
166
Replies
8
Views
325
Replies
4
Views
204
Replies
2
Views
225
Replies
5
Views
152

1,207,286
Messages
6,077,533
Members
446,288
Latest member
lihong3210

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.

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