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
|