Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Using IF Function where logical test is for range of values Using IF Function where logical test is for range of values
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-11-2017, 12:12 PM
xor xor is offline Using IF Function where logical test is for range of values Windows 10 Using IF Function where logical test is for range of values Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
How about:

=IF(A1<200000,"",IF((A1>=200000)*(A1<300000),0.02, 0.04)*(A1-200000))
Reply With Quote
 

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using IF Function where logical test is for range of values Help with Index Function to Select Range of Cells bretyuin Excel 1 02-24-2016 05:11 AM
Using IF Function where logical test is for range of values Using Left function to format a range USAOz Excel 4 09-10-2015 03:00 AM
Using IF Function where logical test is for range of values 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
Using IF Function where logical test is for range of values 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:01 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft