I am doing a financial analysis for a hospital. I want to know how to add something to a number based on conditions. Base pay is $300 for the first 10 patients. If more then ten patients >11-20 add 40 dollars per visit if greater than >21 add 50 dollars per patient
Please help!!!
Thank you
Hi Midorip
Assuming your patient number is in A1, try in B1 or wherever required:
Formula:
Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Re: Adding Based on certain conditions
Thank you so much I was able to apply the formula using the correct cell number and it worked!!
Hi Midorip
No problem and thanks for the feed back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks