Using IF Function where logical test is for range of values

		Microsoft Office Forums > Microsoft Excel > Excel
Using IF Function where logical test is for range of values

FAQ

Thread Tools

Display Modes

02-10-2017, 02:29 PM

guciolino

Using IF Function where logical test is for range of values

Mac OS X

Office for Mac 2011

Novice

Join Date: Feb 2017

Posts: 6

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Index Function to Select Range of Cells	bretyuin	Excel	1	02-24-2016 05:11 AM
Using Left function to format a range	USAOz	Excel	4	09-10-2015 03:00 AM
select a cluster of point from a range based on x and y values	sandcharles	Excel	5	02-19-2015 06:15 AM
Help me with simple IF stmt to test date within a range	tomseeley	Excel	4	02-23-2014 02:13 PM
comparing values from a range	struct	Excel	1	04-01-2011 07:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.