Thread: IF(OR - IF(AND // Formula Help
View Single Post
 
Old 09-06-2017, 10:17 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
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