#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
conditional formatting - I am confused | parachamk | Excel | 1 | 07-03-2014 09:54 AM |
+IF(RAND()........) confused newbie | jeffk | Excel | 6 | 05-28-2013 08:03 AM |
Range Lookup for Totals? Confused | lawnG | Excel | 1 | 02-01-2011 10:42 AM |
Field Lookup - Confused | lawnG | Word Tables | 1 | 01-31-2011 03:50 PM |
Need Backup/Export - confused! | Robin12265 | Outlook | 2 | 06-04-2006 10:38 AM |