I have an "IF"Statement problem...please help!!
 

Hi, Thank you for all Of your help...This Is the problem.


It is $.99 toake a phone call,
Calls 20 minutes or less are charged no extra fee
Calls more than 20 minutes are charges $.08 for each minute over 20
minutes in addition to the $.99 charge to make the call


Thanks again


--
cmk0007
------------------------------------------------------------------------
cmk0007's Profile: http://www.excelforum.com/member.php...o&userid=16103
View this thread: http://www.excelforum.com/showthread...hreadid=275499

Try this:

=(A120)*(A1-20)*0.08+0.99
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"cmk0007" wrote in message
...

Hi, Thank you for all Of your help...This Is the problem.


It is $.99 toake a phone call,
Calls 20 minutes or less are charged no extra fee
Calls more than 20 minutes are charges $.08 for each minute over 20
minutes in addition to the $.99 charge to make the call


Thanks again


--
cmk0007
------------------------------------------------------------------------
cmk0007's Profile:
http://www.excelforum.com/member.php...o&userid=16103
View this thread: http://www.excelforum.com/showthread...hreadid=275499