addition with a maximum value

D

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
 
R

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]
 
Top