multiply specific cells

  1. X

    Conditional Multiplying

    Hello people! I am quite new to proper work in excel and I need some help! I have this table with sales and revenues from the months december 2014 and january 2015, the sales and revenues are made in 5 currencys, FX rates are given in another sheet . I need to calculate everything in euros...
  2. B

    Can't set macro range in VBA

    Hello. I need my macro to automatically multiply the value I enter in the cell (by *9.81) and to return the result to the same cell. I have gotten this code, but I can't set the Range of my macro to work in. I would like this macro to work just in columns BH:BJ, BM:BO, BR:BT, BW:BY, CB:CD...
  3. L

    Multiply cell by varying percent based on cell value.

    I've tried to find an answer here but I actually don't know the correct name (if there is one) for this formulation. What I'd like to do is multiply a cell by say 10% but only if the cell is equal/less than $100.... or... multiply by 5% if the cell is greater than $100. I have a range of...
  4. M

    Alternative to IF function

    In my spreadsheet I need a formula to automatically calculate the HST/GST based on which province the purchase order is being created for. Example: I'm doing a purchase order for a company in Ontario. We need to charge 13% HST on that purchase order because that company is in Ontario...
  5. Beginner35

    Is there a better way to Mutiply and then Add than below?

    Hello: Is there an easier formula to do this Total Cost=( Unit Price1 x Qty1 + Unit Price2 x Qty2 + Unit Price3 x Qty3 + Unit Price4 X Qty4 etc.... ) <tbody> 1 A D E 2 Unit Price HW Shipping Rate per item L 3 $5,000 $29 1 4 $6,000 $29 2 5 $7,000 $29 3 6 $8,000 $59 4 7...
  6. J

    Multiply only if followed by certain character

    Good Afternoon, I am using a Mac Pro, with Excel for Mac 2011, and I am having a problem trying to multiply a certain set of values followed by an exact letter. To be more in-depth I have varied numbers followed by a letter at certain character places and what I was wanting Excel to do was get...

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?

Disable AdBlock

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
Back
Top