Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel PMT Function Help
So im having some trouble doing this Excel spreadsheet. Mainly because im terrible with numbers and math. I kind of need step by step directions for somethings and this is one of them even though you guys may seem like this is a walk in the park. Im just having a little trouble with the damn PMT function.
If anyone could help me that would be fantastic! Anyways heres what the problem goes. 1. Your friend has made several visits to the doctors office in the past month and he has asked you to calculate what will be owed after the insurance has been paid. The insurance company usually takes a month to process a claim and your friend is hoping you can help figure the amount right away so he or she can plan ahead. 2. Date of Visit 2/4/2010 2/5/2010 2/11/2010 2/12/2010 2/15/2010 2/18/2010 2/19/2010 2/22/2010 2/25/2010 2/27/2010 2/28/2010 Doctor Goodman Goodman Loman Goodman Loman Loman Loman Walker Walker Loman Goodman Cost of Visit $113.00 $145.00 $120.00 $110.00 $140.00 $175.00 $135.00 $215.00 $235.00 $120.00 $105.00 3. Your friend has a co-payment of $25.00 and insurance will pay 80% of the remaining cost. Creat a formula for each visit that will calculate the amount your friend will have to pay. 4. The insurance company is suppose to respond within 30 days of billing. The doctors off have said they will bill within 3 days of the visit. Add a column that will indicate the date the insurance company will respond for each visit. END The Date of Visit, Doctor, Cost of Visit are 3 separate columns. So like A1,B1,C1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel PMT Function Help
"Harkins1721" wrote:
Im just having a little trouble with the damn PMT function. If anyone could help me that would be fantastic! Here's a hint: your homework assignment has nothing to do with the PMT function. Beyond that, you really should seek the aid of the class TA or instructor, or a friend in the class. ----- original message ----- "Harkins1721" wrote in message ... So im having some trouble doing this Excel spreadsheet. Mainly because im terrible with numbers and math. I kind of need step by step directions for somethings and this is one of them even though you guys may seem like this is a walk in the park. Im just having a little trouble with the damn PMT function. If anyone could help me that would be fantastic! Anyways heres what the problem goes. 1. Your friend has made several visits to the doctors office in the past month and he has asked you to calculate what will be owed after the insurance has been paid. The insurance company usually takes a month to process a claim and your friend is hoping you can help figure the amount right away so he or she can plan ahead. 2. Date of Visit 2/4/2010 2/5/2010 2/11/2010 2/12/2010 2/15/2010 2/18/2010 2/19/2010 2/22/2010 2/25/2010 2/27/2010 2/28/2010 Doctor Goodman Goodman Loman Goodman Loman Loman Loman Walker Walker Loman Goodman Cost of Visit $113.00 $145.00 $120.00 $110.00 $140.00 $175.00 $135.00 $215.00 $235.00 $120.00 $105.00 3. Your friend has a co-payment of $25.00 and insurance will pay 80% of the remaining cost. Creat a formula for each visit that will calculate the amount your friend will have to pay. 4. The insurance company is suppose to respond within 30 days of billing. The doctors off have said they will bill within 3 days of the visit. Add a column that will indicate the date the insurance company will respond for each visit. END The Date of Visit, Doctor, Cost of Visit are 3 separate columns. So like A1,B1,C1 -- Harkins1721 |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Adding a custom function to the default excel function list | Excel Programming | |||
When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming |