I need two different formulas:
FP is paid at $53/encounter: G*H (H is a constant $53.00). But could have a FP and Partner on the same line of compensation.
Partner is paid at G*17B (17B will be input monthly).
How do I automatically calculate column P?
Do I have to copy and paste the calculations for column A "partners?" as depicted in line 46 for all of the other partners?
Last edited by chickieram63; 02-10-2012 at 07:26 PM. Reason: Using Excel 2011 for Mac
Hi Chickieram
I'm struggling to understand this. I think the maths and formulae are fairly easy, but I don't understand what you need.
Are you staying that, when there is a "Partner" shown in column A, you use the value in B17 instead of the $53.00?
If this is it then:
Copy these formula from Row 23 to all the other rows. They should adjust automatically when Partner is in column A.CELL H23: =IF(ISERROR(FIND("PARTNER",UCASE(A23))),$H$19*G23,0) CELL J23: =IF(ISERROR(FIND("PARTNER",UCASE(A23))),0,$B$17*G23) CELL P23: =SUM(J23-K23+L23+H23+I23)
Best regards, Rob.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks