0
Assume:
Days in month/billing period = x (29/30/31)
Days that user has service = y (0<y<x)
Monthly cost of service = z
Then in an Excel cell you would enter:
=z*(y/x)
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
How do you prorate interest?
how do I prorate interest in a closing statement
What does daverage do in Excel?
It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.
Excel helps organize and identify your files by using what?
Excel can access a file manager. Excel helps you organize and identify your files by using Document Properties.
What is an excel query?
Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.
What are excel characters?
excel characters are symbols like @ instead of using the word at.
How do you get answer to your questions when using Excel?
You use formulas to do calculations and get a result. For problems you have using Excel, you can go to classes to learn more or learn from books or post questions to Excel websites where experts can answer.
What are possible limitations using macros within Microsof Excel?
What are possible limitations using macros within Microsoft® Excel
How Excel 2007 Converted to Excel 2003?
You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.
Does Excel store dates and times using text?
No. Dates and times are stored as numbers in Excel.
Is hardware or software used in Excel?
Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.Excel is software.
Excel helps you organize and identify your files by using which are the details about a file?
Excel is not a file manager. However, you can organize Excel files by storing them in folders for specific purposes.
How do you use Jaws to read a comment in Excel?
press ctrl_shift_apostrophe to announce an Excel comment using JAWS
