Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking Columns and cells
I have columns that are linked as follows:
Age (I) reads =IF(AND(O5='',K5=""),"",(O5--K5)/365) Federal Poverty Level (J) reads =IF(I5="","",IF(I5=45,"F","S")) Federal or State defined by Age & Fed Poverty Level (N) reads =IF(AND(J5="",L5=""),"","CBCCEDP-"&IF(AND(J5="F",L5="F"),"FED","STATE")) Cost of Procedure (S) which is linked to Procedure Code (Q) and Procedure discription (R) reads =IF(ISNA(MATCH(Q5,CPT!$B$3:$B$72,FALSE)),"0",VLOOK UP(Q5,CPT!$B$3:$D$72,3,FALSE)) NOW I NEED RUNNING DOLLARS SPENT/TOTALS TO COME OUT OF EITHER FEDERAL -cell L2 AND STATE - cell O2, DEPENDING ON THE CRITERIA THAT IS DEFINED IN COLUMN N5. QUESTION: How do I link the cost column to the federal dollars spent and state dollars spent, given column N5 -i.e., if the age is 34 yr old and the poverty level is above 200% it will the cost will come out of state funds. If the age is 50 and poverty level is below 200% then the cost will come out of federal dollars. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns | Excel Worksheet Functions | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
count cells across muliple columns | Excel Worksheet Functions | |||
formulas against columns not cells | Excel Worksheet Functions |