Lynn,

Let me see if I have this right.
If A5/2 <=250 then A6=2.54 +2 (ie 4.54)
If 250< A5/2 <=500 then A6=2.54 + A5/2/250*2
If A5/2500 then A6= 2.24 + A5/2/250*2

If this is correct then we can simplify the formula significantly by not
dividing A5 by 2 but doubling the limits (to 500 & 1000). We then need to
double the divisor to 500, but as we are then multiplying the sum by 2 we
can just divide by 250. Does this make sense?

Try this in A6:

=IF(A5<=500,4.54,IF(A5<=1000,2.54+(A5/250),2.24+(A5/250)))

--
Ian
--

"Lynn" wrote in message
oups.com...
Here's my problem:

First I need A5 to be divided by 2.

Second Part: Whatever that number may be - if greater than or equal to
500 then $2.24. if less than or equal to 499 then $2.54

Third part: If first part answer is less than or equal to 250 then it
needs to add together the second part with $2.00. if the first part is
greater then 250 then it needs to be divided by 250 and that number
multiplyed by $2.00 and added to the answer to the second part for an
answer in A6.

Hope I didn't make this too confusing. Thanks!!