Max formulas that use the maximum of each

[ssminnow]

I currently have a formula that works. - Max((x28*$Z$7)-y28,0 This takes the maximum of (x28*$Z$7) minus y28 and enter the amount. Correct!

I want to take the max of two numbers ($Z$7and F28) and then multiply that number by x28 and then minus y28 to get the amount.

Any ideas?

[63falcondude]

I want to take the max of two numbers ($Z$7and F28) and then multiply that number by x28 and then minus y28 to get the amount.

Try

=MAX(Z7,F28)*X28-Y28

[63falcondude]

Also, referring to the first line of post #1, note that X28*Z7 will give you the same result as MAX(X28*Z7).

X28*Z7 will return a number and the max of a number is that number.

[ssminnow]

Something is not right. In laymans terms I want the max of $10.00(z7) or $10.50(f28) times x28 and then the max of that or 0 minus y28

[oeldere]

@ssminnow

I am interested in the result you expect for your given criteria.

[ssminnow]

=MAX(Z7,F28)*X28-Y28 formula is correct however I am getting a negative number. If negative I want it to be 0.

[Root_]

Maybe

=MAX(0,MAX(Z7,F28)*X28-Y28)

[63falcondude]

You're changing the requirements.

The following formula gives you exactly what you're asking for in post #4. The lack of commas make it a little challenging to understand though.

=MAX(MAX(Z7,F28)*X28,0)-Y28

[ssminnow]

That works now. Thanks.

[63falcondude]

I'm not sure who's response you are referring to but I'm glad that you now have a working solution.

Glad we could help.