-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
max formula
-
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...- david col
- Thread
- max and sum max formula min based on criteria
- Replies: 3
- Forum: Excel Questions
-
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...- jshonuff
- Thread
- column greater max max and min max formula
- Replies: 5
- Forum: Excel Questions
-
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.- jshonuff
- Thread
- column1 column2 max max and min max formula
- Replies: 1
- Forum: Excel Questions
-
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- richiwatts
- Thread
- calculation default formula max formula rich
- Replies: 3
- Forum: Excel Questions
