Need to know how to write a calculation...
=IF(B10*120%2700,2700,B10*120%)
I've assumed you want the base increased by 20% and not 20%of the base
price.
Regards.
Bill Ridgeway
Computer Solutions
"Mary A Perez" wrote in message
...
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
|