View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary A Perez
 
Posts: n/a
Default Need to know how to write a calculation...

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