Thread: [Solved] Using IF Function where logical test is for range of values
View Single Post
 
Old 02-10-2017, 02:29 PM
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 Using IF Function where logical test is for range of values
Hi,

Can someone help me with this formula, please:

A customer gets a rebate once he reached a specific amount of sales:

over $200000 (and until 299999) 2%, when the customer reached $300000 then he gets a rebate of 4% back of everything over $200000.

I tried ( but I am a newbie ) :

=IF(G21>=200000,G21*0.02,IF(G21>=300000,G21*0.04))

Thanks in advance
Reply With Quote