Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2018, 12:11 PM
Kubi Kubi is offline if greater than equal to Windows XP if greater than equal to Office XP
Advanced Beginner
if greater than equal to
 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default 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?
Attached Files
File Type: xlsx Surefoot Order Sheet.xlsx (13.8 KB, 7 views)
Reply With Quote
  #2  
Old 02-19-2018, 12:12 PM
Kubi Kubi is offline if greater than equal to Windows XP if greater than equal to Office XP
Advanced Beginner
if greater than equal to
 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 02-19-2018, 01:45 PM
ArviLaanemets ArviLaanemets is offline if greater than equal to Windows 8 if greater than equal to Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Code:
=MAX(YourFormula,YourMinValue)
Reply With Quote
Reply

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 greater than equal to If A1 greater than or equal to 1 Then A3 = A2*A1 brians Excel 5 03-09-2010 12:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft