+ Reply to Thread
Results 1 to 3 of 3

How do I set a price minimum in a spreadsheet?

  1. #1
    phahn
    Guest

    How do I set a price minimum in a spreadsheet?



  2. #2
    Nigel
    Guest

    Re: How do I set a price minimum in a spreadsheet?

    =MIN(A1:A100)

    will return the minimum value in the range A1 to A100

    --
    Cheers
    Nigel



    "phahn" <[email protected]> wrote in message
    news:[email protected]...
    >




  3. #3
    Tom Ogilvy
    Guest

    Re: How do I set a price minimum in a spreadsheet?

    Here is another guess.

    =if(calcuated price < minimum price, minimum price, calculated price)

    or

    =max(calculated price,minimum price)

    --
    Regards,
    Tom Ogilvy

    "phahn" <[email protected]> wrote in message
    news:[email protected]...
    >




+ Reply to Thread

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