Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with the IF formula
i have created a payroll spreadsheet and now im currently having issues with
adding the tax. The tax goes like this: if $346 - $480 deduct $63 and 25c for each dollar over $346 $481 - $672 deduct 96 and 40c for each dollar over $481 i just need help in how i'd go about making a formula like that. there is alot more like that but i'd be able to figure it out i just need to know how i would go creating such a formula? |
#2
|
|||
|
|||
http://www.mcgimpsey.com/excel/variablerate.html
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Asta" wrote in message ... i have created a payroll spreadsheet and now im currently having issues with adding the tax. The tax goes like this: if $346 - $480 deduct $63 and 25c for each dollar over $346 $481 - $672 deduct 96 and 40c for each dollar over $481 i just need help in how i'd go about making a formula like that. there is alot more like that but i'd be able to figure it out i just need to know how i would go creating such a formula? |
#3
|
|||
|
|||
The last reply did help kind of. but its way to confusing for me. I've been
stuck on this problem for about 10 hrs now and i have to hand it in on monday and i really need to finish the rest which is dependent on that lil bit "Asta" wrote: i have created a payroll spreadsheet and now im currently having issues with adding the tax. The tax goes like this: if $346 - $480 deduct $63 and 25c for each dollar over $346 $481 - $672 deduct 96 and 40c for each dollar over $481 i just need help in how i'd go about making a formula like that. there is alot more like that but i'd be able to figure it out i just need to know how i would go creating such a formula? |
#4
|
|||
|
|||
the deductions are not clear. as far as I understood I give the vba sub
which you can run. The data is in B7 to B19 Public Sub test() Dim cell As Range For Each cell In Range("B7:B19") cell.Activate If ActiveCell = 346 And ActiveCell <= 480 Then ActiveCell.Offset(0, 1) = 63 + 0.25 * (ActiveCell - 346) If ActiveCell = 481 And ActiveCell <= 672 Then ActiveCell.Offset(0, 1) = 96 + 0.4 * (ActiveCell - 481) Next End Sub see wthether logic of deduction is correct by checking one or two figures between 346 and 480 and again between 481 and 672 . in C colum you will get the tax deduction. is it ok Asta wrote in message ... The last reply did help kind of. but its way to confusing for me. I've been stuck on this problem for about 10 hrs now and i have to hand it in on monday and i really need to finish the rest which is dependent on that lil bit "Asta" wrote: i have created a payroll spreadsheet and now im currently having issues with adding the tax. The tax goes like this: if $346 - $480 deduct $63 and 25c for each dollar over $346 $481 - $672 deduct 96 and 40c for each dollar over $481 i just need help in how i'd go about making a formula like that. there is alot more like that but i'd be able to figure it out i just need to know how i would go creating such a formula? |
#5
|
|||
|
|||
=IF(AND(A1=346,A1<=480),(A1-346)*63.25,IF(AND(A1=481,A1<=672),(A1-481)*96.40),"no deduction"))
HokieLawrence "Asta" wrote: The last reply did help kind of. but its way to confusing for me. I've been stuck on this problem for about 10 hrs now and i have to hand it in on monday and i really need to finish the rest which is dependent on that lil bit "Asta" wrote: i have created a payroll spreadsheet and now im currently having issues with adding the tax. The tax goes like this: if $346 - $480 deduct $63 and 25c for each dollar over $346 $481 - $672 deduct 96 and 40c for each dollar over $481 i just need help in how i'd go about making a formula like that. there is alot more like that but i'd be able to figure it out i just need to know how i would go creating such a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |