Thread: [Solved] Using IF Function where logical test is for range of values
View Single Post
 
Old 02-11-2017, 06:53 AM
guciolino guciolino is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Feb 2017
Posts: 6
guciolino is on a distinguished road
Default
Hi ,

it is over $200000, no discounts under $200000

$200000 - 299999 2%

but if the customer reached $300000 then he gets 4% back for everything over $200000

Thanks
Reply With Quote