Excel multiple Q2

[ajedrzej]

Hey guys the last time I asked a question.. it was regarding a Max number formula, where I had two different formulas and needed the max number...

the formula was...

=MAX((D5*65)/1000,(E5*26))

Now I'm wondering, is there anyway within this formula (same cell) you can put a minimum.. so the final number cannot be below say the number 65?

Thank you!

Alesia

 

[VoG]

Try

=MAX(MAX((D5*65)/1000,(E5*26)),65)

 

[T. Valko]

Hey guys the last time I asked a question.. it was regarding a Max number formula, where I had two different formulas and needed the max number...

the formula was...

=MAX((D5*65)/1000,(E5*26))

Now I'm wondering, is there anyway within this formula (same cell) you can put a minimum.. so the final number cannot be below say the number 65?

Thank you!

Alesia

Try this...

=MAX(65,MAX((D5*65)/1000,(E5*26)))

 

[ajedrzej]

Awesome!

Thank you once again!

=)

Alesia

 

[T. Valko]

Try

=MAX(MAX((D5*65)/1000,(E5*26)),65)

Quit changing your formula and I'll quit changing mine!

Double doh!!