On Sat, 26 Aug 2006 23:14:01 -0700, jack nelson
wrote:

hi ron,
i said if the A1 less than ten days the result will be the Poundage for the
sales man. if it is more than ten days and less than twenty days no Poundage
if the date more than twenty dates the sales man will get a Deduction
that way help my to calculate the salary for the sales man


Did the formula I provided do what you want?

In your description you do not include what you want to happen if the
difference is exactly equal to ten days or exactly equal to 20 days.

You wrote three conditions:

"less than ten days ...
"more than ten days and less than twenty days ...
"more than twenty dates ...

So you have described what you want to happen if the value is "less than 10
days" or "more than ten days" but neither of those options include the value
being "equal to ten days".


I assumed when you wrote "less than ten days" that you meant "less than or
equal to ten days", and the same with twenty days. If that is not what you
want, you can alter the comparison operators appropriately in the formula I
provided.



"Ron Rosenfeld" ???:

On Sat, 26 Aug 2006 03:29:01 -0700, jack nelson <jack
wrote:

hi all
i want to ask about this calculation:
if i have a date for sell and the date for billing and i want to caculate
the diffrence between them with a quirey if the days more than 10 days the
result no discount and if it is less than 10 days it eill be extra discount
like 3% and if the days more than 20 days that means tax 10% can any body
help me?

A1: Sell Date
B1: Bill Date
C1: Cost

And your specifications don't indicate what you want to happen if the days is
exactly equal to ten days, so I made an assumption:

=C1*IF((B1-A1)<=10,0.97,IF((B1-A1)<=20,1,1.1))
--ron


--ron