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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 10:50 AM.