+ Reply to Thread
Results 1 to 8 of 8

the maximum and minimum limit

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    mannargudi
    MS-Off Ver
    Excel 2003
    Posts
    4

    the maximum and minimum limit

    I have a simple multiplication =(10,00,000*1%) the result will be 10,000. and this is the maximum limit.,

    if the number is increases the result should be 10000

    ir the number decreases the result should be as per the multiplication

    is there an easy way to do that?



    Thanks for your help
    sethu

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: the maximum and minimum limit

    Here!

    =IF(1000000*1%>10000,10000,1000000*1%)

    Deep
    Cheers!
    Deep Dave

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,410

    Re: the maximum and minimum limit

    Another option:
    =MIN(A1*1%,10,000)
    Where A1 is variable (1,000,000 or others)
    Quang PT

  4. #4
    Registered User
    Join Date
    03-06-2013
    Location
    mannargudi
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: the maximum and minimum limit

    thank you for your reply.,
    regards
    sethu
    Last edited by madhupangal; 02-20-2014 at 08:14 AM.

  5. #5
    Registered User
    Join Date
    03-06-2013
    Location
    mannargudi
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: the maximum and minimum limit

    thank you it works .,thank you very much


    =MIN(A1*1%,10,000)
    regards
    sethu

  6. #6
    Registered User
    Join Date
    03-06-2013
    Location
    mannargudi
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: the maximum and minimum limit

    dear all.,
    how can i hide my formula [in formula bar] in a cell from other's view

  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: the maximum and minimum limit

    Assuming the formula is in cell A1.

    Select the entire sheet
    Within the sheet grid, Right click>Format cells>Protection tab>Unselect Locked
    OK out

    Select cell A1
    Right click>Format cells>Protection tab>Select Locked and Hidden
    OK out

    Goto the Tools menu>Protection>Protect sheet

    There are various options available. Select which options you want then OK out.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  8. #8
    Registered User
    Join Date
    03-06-2013
    Location
    mannargudi
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: the maximum and minimum limit

    thank you very much.,
    after protection of the sheet or cell
    i want to enter values.,
    do you help me.,
    regards
    sethu

  9. #9
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: the maximum and minimum limit

    Yu should be able to enter data in other cells. You only protected 1 cell, cell A1 with the formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Getting the maximum & Minimum value in a range
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-13-2013, 12:39 PM
  2. [SOLVED] Sum minus up to a maximum and a minimum
    By Rompetelo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2013, 03:58 AM
  3. Maximum and Minimum
    By lurchybold in forum Excel General
    Replies: 6
    Last Post: 10-13-2010, 11:04 AM
  4. Maximum and minimum cell value
    By sharkfoot in forum Excel General
    Replies: 3
    Last Post: 03-05-2006, 07:10 PM
  5. [SOLVED] Recording maximum and minimum
    By F in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2006, 02:30 PM

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