Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with a formula
Hi - I'm pretty much an excel newbie, and I need a little help with a
formula. I need to take the annual salary, which is the (comp rate * 2080), round it up to the nearest 1000, multiply it by the salary factor, then if it is over 89,000, round it down to 89,000. That last part is what is eluding me, is there any way to do it? I'm also not quite sure how to do the rounding, though I imagine I can figure that out. Thanks in advance for any help. G H I Comp Rate Annual Salary Salary Factor $27.80 $57,824.00 1.0 $17.96 $37,356.80 1.0 $21.78 $45,302.40 0.5 $15.89 $33,051.20 1.0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |