S
Steve Lenaghan
I need Excel to do a math function that I cannot seem to find in the
manuals.
I have a small answering service that charges extra if a customer goes over
a certain limit of calls.
What I need is a formula that will allow me to put the actual number of
calls in a cell and provide a result in another cell ONLY if the number
exceeds a defined value.
Now this becomes slightly more complicated. We have two levels of extra
charges. The first is actual messages recorded in excess of a preset value.
The second is the number of calls received that exceed the previous preset
value.
Where this becomes difficult is when both numbers come into play.
There are situations where a customer has calls in excess but no messages in
excess and occasionally both occur. In this situation the calls in excess
are calculated after the message in excess since the answering computer
supplies only two numbers. The total calls and the total messages. The
message count is part of the call count. Clear ???
Anyway its probably a simple matter and if I was still using 1-2-3 I could
work out a formula, but Excel has lost me.
TIA
Steve L
manuals.
I have a small answering service that charges extra if a customer goes over
a certain limit of calls.
What I need is a formula that will allow me to put the actual number of
calls in a cell and provide a result in another cell ONLY if the number
exceeds a defined value.
Now this becomes slightly more complicated. We have two levels of extra
charges. The first is actual messages recorded in excess of a preset value.
The second is the number of calls received that exceed the previous preset
value.
Where this becomes difficult is when both numbers come into play.
There are situations where a customer has calls in excess but no messages in
excess and occasionally both occur. In this situation the calls in excess
are calculated after the message in excess since the answering computer
supplies only two numbers. The total calls and the total messages. The
message count is part of the call count. Clear ???
Anyway its probably a simple matter and if I was still using 1-2-3 I could
work out a formula, but Excel has lost me.
TIA
Steve L