Need to know how to write a calculation...

Giganews Newsgroups
Subject: Need to know how to write a calculation...
Posted by:  Mary A Perez
Date: Tue, 30 May 2006

I need to take the $ amount in b10 & mulitply it my 20% but tell the formula
that if the result is >$2,700 just put $2,700 in the answer.
Can someone write this out for me?
Thank you

Replies