Min & Max combined formula

[husni]

Dear All,

Please help me with this MIN & MAX combination formula.

MIN(30,D8+D23+D29+D47)
MAX(0,D8+D23+D29+D47)

Please help me.....

Thanks

[boopathiraja]

Hi, Can you explain your requirement...

[husni]

Eg:

Cell A1 = number (maximum after add numbers is 30, however, if the number is <0, eg: -2, the cell shall be 0)

Can you understand this sir?

Really need that MAX formula & MIN formula combination.

Maybe there is another formula to have max value = 30, min value = 0.

Thanks

[boopathiraja]

Probably this ?

=MAX(0,MIN(30,D8+D23+D29+D47))

[husni]

Its work!

TQVM sir.

[protonLeah]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-gene...d-formula.html