Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
vnoble - 02 Feb 2007 15:08 GMT
Need a formula for the following please:

Rate  4.95%
Upto 3,500 exempt ie; to $ 3,500
Maximum 43,500 - Maximum charge is $43,500
JLatham - 02 Feb 2007 15:22 GMT
Exactly what are you trying to calculate?  Using the values you've given,
tell us what you intend to do with them and what your expected result is,
please.

But maybe something like this:
A1 = 4.95%
A2 = 3500
A3 = 43500
A4 = user entered value (as 45000)
formula could be
=IF(A4-A2>A3,"Too Much",IF(A4<=A2,0,(A4-A2)*A1))
which says
if the amount after subtracting 3500 from the user entered value is greater
than the limit set in A3 (43500) then say "Too Much", but if that is ok, then
if the user entered value is below the exempt value, then show zero,
otherwise, take the user entered amount, subtract the exempt amount from it
and multiply that by the percentage in A1 and show the result: 2054.25 in my
example using 45000 as the user entered value.

> Need a formula for the following please:
>
> Rate  4.95%
> Upto 3,500 exempt ie; to $ 3,500
> Maximum 43,500 - Maximum charge is $43,500
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.