Telephone Bill

I use to get monthly bill for my Company and I have to arrange the bill for
our staff as follows.  How to do this in excel formula ?

If   PRIVATE CALL  <= $200  the calls are free for staff.  The staff have to
pay to
the company for all more than $200 PRIVATE CALLS .  So there are 4 coulums
as follows :
BILL AMOUNT
BUSINESS CALL
PRIVATE CALL
DUE FROM EMPLOYEE

If you are excepting the below mentioned answers in ColD then try thisformula

If you are excepting the below mentioned answers in ColD then try this
formula in cell D2 and copy down as required

=MAX(0,C2-200)

Col C	Col D
Private	Due
250	50
50	0
200	0

If this post helps click Yes
---------------
Jacob Skaria

The answer was not clear to me."Jacob Skaria" wrote:

The answer was not clear to me.

Jacob's Formula First DEDUCTS $200 from the total bill.

Jacob's Formula First DEDUCTS $200 from the total bill.
For those Total Bills that are LESS then 200 the result is a NEGATIVE (-100)
for (100-200)  - But if the Total Bill is 300 then a positive of 100 (300-200)

Then the MAX() kicks in and says, Give me whichever is HIGHER,  0, -100
And 0 is Higher!!   Then whichever id higher  0, 100  >> of course 100 is
Higher!

OK?

Choice gets the MAXIMUM of Either:
0 (Zero)

Post sample data with the desired results...

Post sample data with the desired results...

If this post helps click Yes
---------------
Jacob Skaria

I would have thought it was $200 per month that is allowed, not $200for each

I would have thought it was $200 per month that is allowed, not $200
for each call.

Hope this helps.

Pete

s
bill for
=A0The staff have to
4 coulums