How to make : if ( sum of cells)<422.10 then display in this cell 422.10

[p.ocho]

Hi guys

Spent a while trying to find an answer to my problem but failed with my searches.

Basically I got a column of values from g1 to g5 and then sum of them in g7.

I want if the sum ics lower than 422.10 then display this value, if higher then display actual value of the sum.

Any help would be much appreciated

[Xx7]

Put this formula in G7... =IF(SUM(G1:G5)<422.1,422.1,SUM(G1:G5))

[Pepe Le Mokko]

Alternatively try

Please Login or Register  to view this content.