Could I ask that you rephrase, or describe the needs a little differently.
I'm having a problem determining just what it is you need. Also, don't use
anything that might be misunderstood as a math symbol except when it is a
math symbol (dash can be confused with minus sign or subtraction).

Part B is easy, I think: formula in cell would be
=.1528/.18
will display the result (0.84888889) can be formatted to display 0.849.

Back to part A, maybe describe something like this:
if claim is greater than or equal to (=) some value
Then do this with it: claim * .956 * factor,
OR
if do this with claim amount...
perform another test: if claim - amount = some other value
Then do this ... describe another calculation

continue on in that fashion. Don't worry if you have to use some other test
like is less than or is equal to, that's fine. If you don't know the
symbols, just spell it out, we'll do our best to figure it out. Use as many
IFs, Thens and Ors as it takes.


"dmritter" wrote:

i need to figure out the following for every claim i receive and i would like
help putting in a formula A. 62,660 *.956 = 59903 *factor or - 3133 =56770
* factor 0r - 3236 = 53534 *0 .18 = $936.12 that is part A
Part B 0.1528/ 0.18 =0.849

if anyone could please help me that would be wonderful