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

02-11-2017, 01:54 PM

guciolino

Mac OS X

Office for Mac 2011

Novice

Join Date: Feb 2017

Posts: 6

Quote:

Originally Posted by Pecoflyer

Perhaps =IF(A1>=300000,(A1-200000)*0.96+200000,MAX(0,A1-200000)*0.98+MIN(A1,200000))
where A1 contains the sale

=IF(G21>=300000,(G21-200000)*0.96+200000,MAX(0,G21-200000)*0.98+MIN(G21,200000))

This shows me Err:508

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:17 PM.