Results 1 to 2 of 2

Need help with insurance calculation tool

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need help with insurance calculation tool

    I am a beginner when it comes to creating formulas in excel, but have been tasked to create a spreadsheet which calculates what a patient's responsibility will be for an exam. I have been using Google and You tube to teach myself the basics of how to create some of these formulas, but am at an impasse right now. I am trying to figure out how to create formula that will add the fee from column U4 to the value that is displayed in I4. So whatever value is selected in A4-A6 and whatever insurance is selected in C4, will correspond to the total value in T4-U4. If a patient is being seen for a CT head w/ and the Price is $200 I need the corresponding pro fee for the CT head w/ added to the total owed and so on. I don't know if I am explaining this correctly, but any assistance would be greatly appreciated.

    Thanks,

    Drew
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1