Thread: Telephone Bill
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Telephone Bill

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


"Kutty" wrote:

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