Results 1 to 3 of 3

formula for unit price with minimum amount

Threaded View

yvanblanchette formula for unit / minimum... 02-25-2008, 09:56 PM
Leith Ross Hello Yvan, The formula in... 02-25-2008, 11:22 PM
yvanblanchette This works to some extent... 02-25-2008, 11:55 PM
  1. 02-25-2008, 09:56 PM #1
    yvanblanchette is offline
    Registered User
    Join Date
    02-19-2008
    Posts
    6

    Question formula for unit / minimum amount Not working

    I am creating a price list and need to incorporate a minimum charge if the doesn't reach a specific number...


    ex: A = Qty B = $60 unit price or $180 minimum charge
    The result needs to be 180 if lower than 2.999

    What is the formula to get this result in B?

    <3 would = $180
    >=3 = $60 per A

    Thanks in advance for all your help.

    Yvan
    Last edited by yvanblanchette; 02-26-2008 at 08:36 AM. Reason: More help needed
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1