#1
|
|||
|
|||
if greater than equal to
I have a sheet that adds up a customers weight and cube for shipping however there are minimum cost that need to be applied if the cubic meter is to low, as shown at the top.
The per cubic meter cost is in red which is what the total order cube is multiplied against to get the cost the the minimum cost is shown in yellow next to this, how do i get the sheet to apply the correct one? |
#2
|
|||
|
|||
i have made the sheet so the customer can fill in their customers order of units and address city and the sheet will auto fill the rest.
|
#3
|
|||
|
|||
Code:
=MAX(YourFormula,YourMinValue) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu | AlanBird | Excel | 3 | 11-25-2017 03:11 PM |
formula using equals/greater than etc signs | msnarayanan | Excel | 2 | 02-25-2016 08:21 AM |
Need help with excel formula greater than.. | bm868 | Excel | 2 | 01-02-2016 10:29 AM |
outlook 2000 pst greater than 2gb | bbxrider | Outlook | 0 | 09-25-2010 02:37 PM |
If A1 greater than or equal to 1 Then A3 = A2*A1 | brians | Excel | 5 | 03-09-2010 12:04 PM |