Results 1 to 9 of 9

Excel for calculating charges min. max. cap

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2012
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    6

    Excel for calculating charges min. max. cap

    hi all experts,

    i need this very urgently.

    i need a code to calculate the amount of charges and if the value is < 5 the value will be 5 and if it is over 50, it is cap at max 50.

    the % is 0.03125.

    this code will calculate the amount of charges.

    for example, if user type in 10,000. the code will calculate 10000 x 0.03125% and the value is 3.125 but i need the value to be shown as 5 (min. cap at 5).

    if user type in 300,000. the code will calculate 300,000 x 0.03125% and the value is 93.75 but i want the value to be cap at 50.

    please assist. thank you.
    Last edited by mojokid; 04-23-2012 at 03:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1