+ Reply to Thread
Results 1 to 2 of 2

Need help with insurance calculation tool

  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

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Need help with insurance calculation tool

    It sounds like you just want to add to whatever is already in I4???

    I4 = whatever + U4

    A logical operator is treated as just another term once it's evaluated, so having something like:

    I4 = IF(check, number, other_number) + U4

    is perfectly valid; it will assess the IF, and whichever is produced ("number" or "other_number"), it will add the value from U4 to that.

+ Reply to Thread

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