Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-03-2011, 04:56 AM
robbiemer robbiemer is offline I Need Help Windows XP I Need Help Office 2007
Novice
I Need Help
 
Join Date: Aug 2011
Posts: 2
robbiemer is on a distinguished road
Default thank you

with a little 'tweeking' i managed to get it working this is the final formula =IF(A2<9.99,A2*F2,IF(A2<99.99,A2*F3,IF(A2>100.01, A2*F4)))
Reply With Quote
 

Tags
formulas, spreadsheets



Other Forums: Access Forums

All times are GMT -7. The time now is 09:51 AM.


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