|
|
#1
02-19-2018, 12:11 PM
|
|||
|
|||
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? 
|
|
|
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 |
Windows XP 
Office XP
Threaded Mode