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
Bookmarks