Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
dlvv
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arithmetical Mode Value for Filtered cells in Multiple Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 September 8th 05 12:23 AM
Formula to delete blank cells across multiple columns? SamFunMail Excel Worksheet Functions 2 September 1st 05 07:05 AM
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 19 July 18th 05 06:09 PM
count cells across muliple columns Robb27 Excel Worksheet Functions 3 April 15th 05 05:57 PM
formulas against columns not cells Gary Excel Worksheet Functions 1 December 20th 04 06:04 PM


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"