addition with a maximum value

[djarcadian]

I have the following code

=SUM(D10+E10)

but I don't want the results to display anything over 20.

How do I accomplish this

 

[scottymelloty]

Try this

=IF(SUM(D10+E10)>20,20,(SUM(D10+E10-20))

 

[Rizitsu]

=IF(C30>=21,20,20)


C30 is your cell,

IF your cell is more than or equal to 21 , cell equals 20, if it isn'
it equals 20 anyway.

if you take note of the help whilst writing a function you will see th
parenthesis for writing the correct formula.

i.e. IF(logical_test, [value_if_true],[value_if_false]

 

[Dana DeLouis]

Would this work?

=MIN(D10+E10,20)