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

C

cmk0007

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
 
R

RagDyer

Try this:

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

HTH,

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



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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Phone Bills Help Please 4
SUMIF with OFFSET 5
MS Word 2007 files taking too long to open after new internet connection 5
Messy Formuula Needs Clean up Help: Part 2 (Clarification Please)! 5
How do I create the formula for this calculation? 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Help 1
HELP! I need to make an IF Statement comparing date/time fields.. 2

Top