max formula

  1. D

    Max formula for multiple columns

    Hi I have a sheet where I am looking for a formula to add to C14,D14,E14,F14.G14 & H14 to calculate 15% of C13,D13,E13,F13,G13 & H13 up to a limit e.g. the maximum is 20,000 over a few months month. E.G if profit is sufficient in cells C14,D14 & E14 or any combination of columns where 15|% of...
  2. J

    If Greater than this column and this column then Max and Min and display this cell

    <tbody> NAME A B C D 0% 1 561 91% 2 560 86% A 0% </tbody> If Column A is Greater than 0 and Column B is greater than 90, then find the MAX of column B, and display Name Cell. It should give you (1). Also the same as above but instead of MAX I need the MIN...
  3. J

    If this is the MAX In one column then put this from another column

    <tbody> Column1 Column2 2 150% 3 100% </tbody> How do I write, get the MAX value from column2 and Display the name for column1 to another cell in a formula? So the answer should be (2) This is only based on the max value and nothing else.
  4. R

    Max formula (=MAX(A11*B11, 70))

    I use the formula to default to 70 if A11*B11 is less than 70. How do I change this so it doesn't default to 70 if the calculation is 0? Rich
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top