Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page IF(OR - IF(AND // Formula Help
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2017, 01:15 PM
Pixie Pixie is offline IF(OR - IF(AND // Formula Help Windows 10 IF(OR - IF(AND // Formula Help Office 2016
Novice
IF(OR - IF(AND // Formula Help 		 
Join Date: Sep 2017
Posts: 1
Pixie is on a distinguished road
Exclamation IF(OR - IF(AND // Formula Help
I've been working on this for a couple days, in between other assignments. I can't seem to find the right formula to get this to work. Not sure if VB is needed or not. I attached a pic of the tables as well as my question. Any help is appreciated.





Attached Images
File Type: png excel help.PNG (26.6 KB, 16 views)
Reply With Quote
  #2  
Old 09-06-2017, 10:17 PM
xor xor is offline IF(OR - IF(AND // Formula Help Windows 10 IF(OR - IF(AND // Formula Help Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
With KG in B2 maybe this one:

=LOOKUP(B2,{0,45,100,300,500,1000}+0.01,{100,110,2 00,220,300,330})
Last edited by xor; 09-07-2017 at 02:16 AM.
Reply With Quote
  #3  
Old 09-06-2017, 11:12 PM
ArviLaanemets ArviLaanemets is offline IF(OR - IF(AND // Formula Help Windows 8 IF(OR - IF(AND // Formula Help Office 2016
Expert
  
Join Date: May 2017
Posts: 873
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
On fly (I haven't Excel available currently):

In Min row, replace texts with numbers, p.e. +100 kg -> 100;

The formula will be
=MAX($D$11,CHOOSE(MATCH($B$2,$E$9:$J$9,1),$E$11:$J $11))
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF(OR - IF(AND // Formula Help Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
IF(OR - IF(AND // Formula Help What formula to use jomwelsh Excel 6 04-07-2016 08:20 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
help with a look up or if formula beb1227 Excel 3 12-31-2011 01:08 PM
IF(OR - IF(AND // Formula Help PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:19 PM.

Contact Us - Privacy Statement - Top

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