Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2021, 01:03 PM
CuriousG CuriousG is offline This should be simple but I'm sooooo confused Windows 10 This should be simple but I'm sooooo confused Office 2016
Novice
This should be simple but I'm sooooo confused
 
Join Date: Jan 2021
Posts: 20
CuriousG is on a distinguished road
Default This should be simple but I'm sooooo confused

I want to create a spreadsheet that will total x number of mileages then multiply the first (up to)10,000 by .45 and everything over 10,000 by .25.



Can anyone help me please?
Reply With Quote
  #2  
Old 02-15-2021, 09:22 PM
gmayor's Avatar
gmayor gmayor is offline This should be simple but I'm sooooo confused Windows 10 This should be simple but I'm sooooo confused Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

From your description what you appear to want is a conditional statement in the cell where you want the result e.g.

=IF(A1 <=10000,A1*0.45,A1*0.25)

where A1 is the cell you wish to evaluate.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 02-15-2021, 09:32 PM
Purfleet Purfleet is offline This should be simple but I'm sooooo confused Windows 10 This should be simple but I'm sooooo confused Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Please add an example worksheet in future so we dont have to waste time recreating data that might be incorrect

try =IF(F12>10000,(10000*0.45)+((F12-10000)*0.25),F12*0.45)
Reply With Quote
  #4  
Old 02-16-2021, 03:11 AM
CuriousG CuriousG is offline This should be simple but I'm sooooo confused Windows 10 This should be simple but I'm sooooo confused Office 2016
Novice
This should be simple but I'm sooooo confused
 
Join Date: Jan 2021
Posts: 20
CuriousG is on a distinguished road
Default Thanks for your help

I think that's exactly the solution I'm looking for. Thank you very much

Your advice to attach a spreadsheet is noted thank you
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
This should be simple but I'm sooooo confused conditional formatting - I am confused parachamk Excel 1 07-03-2014 09:54 AM
This should be simple but I'm sooooo confused +IF(RAND()........) confused newbie jeffk Excel 6 05-28-2013 08:03 AM
This should be simple but I'm sooooo confused Range Lookup for Totals? Confused lawnG Excel 1 02-01-2011 10:42 AM
This should be simple but I'm sooooo confused Field Lookup - Confused lawnG Word Tables 1 01-31-2011 03:50 PM
This should be simple but I'm sooooo confused Need Backup/Export - confused! Robin12265 Outlook 2 06-04-2006 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:21 AM.


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