Thread: [Solved] Using IF Function where logical test is for range of values
View Single Post
 
Old 02-11-2017, 01:54 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
Quote:
Originally Posted by Pecoflyer View Post
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
Reply With Quote