ifs with calculations

  1. Midavalo

    Proportionally splitting a value between cells based on values and conditions

    In my data I have a couple of columns that are added to regularly (Val1 and Val2) from which I need to subtract a total (Calc) into two new columns (Net_Val1 and Net_Val2). I need to subtract my value in Calc proportionately between Val1 and Val2, however there are some conditions that need to...
  2. S

    Countifs Formula

    Hello, I'm looking to get the count of the number of times a month within a year is listed in 2 tabs in excel. Column BU tab in Gone is the Months in the formula Column BV tab in Gone is the Years in the formula Column P in ISRs tab is the Months in the formula Column Q in ISRs tab is the...
    • Sparda142
    • Thread
    • countifs formula ifs with calculations month and year tabs in formulas
    • Replies: 2
    • Forum: Excel Questions
  3. S

    Help with calculations using ifs and minimum

    I need help creating an ifs formula that will calculate based on a minimum number. Here is an example: <tbody> TABLE 1 Widget --Widget Length-- --Widget SF-- $$$PRICE$$$ </tbody> <tbody> TABLE 2 --Widget Length-- --Widget Cost-- 0-24' 5 25'-28' 10 29'-32' 15...

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