Hi all,

I'm trying to input a formula into an excel spreadsheet. The basic formula is =SUM(B1*2%*117.5%)

I need to add into this forumla that if the sum of the calculation is less than 2000 then the result of the sum needs to be 2000 but if it is greater then it needs to be the result of the sum.

Is there anyway i can do this?

Thanks in advance for any help and apologies for my newbie-ness!

Gareth