- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Need to know how to write a calculation...

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

- RE: Need to know how to write a calculation... posted by Ron Coderre on Tue, 30 May 2006
- Re: Need to know how to write a calculation... posted by mrice on Tue, 30 May 2006
- Re: Need to know how to write a calculation... posted by mrice on Tue, 30 May 2006
- Re: Need to know how to write a calculation... posted by Bill Ridgeway on Tue, 30 May 2006