I have a series of coded billing amounts based on (a) whether a procedure is
in an office setting or a facility setting and (b) on how many minutes the
procedure takes. I would like to be able to have Excel automatically enter
the amount of money expect to receive based on (a) and (b) above. Another
issue is categorizing the various locations into either office or facility
setting. So, for example sites 1, 4, 5, and 7 are office settings and sites
2, 3, and 6 are facility settings. In Excel I have entered the location,
the minutes used and the actual procedure code for each date of service. My
goal is to create if/then statements (a function) to take that information
and zero in on the correct cell in a little box in the spreadsheet that would
have the exact amount I am expected to earn for that particular procedure and
then put that into the proper cell. I see examples for "TRUE" or "FALSE" but
not for copying from one cell to another. Any ideas how to do this?

clarification:

how many actual variables will there be?
how many procedure codes are there, and will each procedure have it's own
rate?
will all of the office rates be the same and all the facility rates be the
same or will every one be different?

jat


"Peter Hansen" wrote:

I have a series of coded billing amounts based on (a) whether a procedure is
in an office setting or a facility setting and (b) on how many minutes the
procedure takes. I would like to be able to have Excel automatically enter
the amount of money expect to receive based on (a) and (b) above. Another
issue is categorizing the various locations into either office or facility
setting. So, for example sites 1, 4, 5, and 7 are office settings and sites
2, 3, and 6 are facility settings. In Excel I have entered the location,
the minutes used and the actual procedure code for each date of service. My
goal is to create if/then statements (a function) to take that information
and zero in on the correct cell in a little box in the spreadsheet that would
have the exact amount I am expected to earn for that particular procedure and
then put that into the proper cell. I see examples for "TRUE" or "FALSE" but
not for copying from one cell to another. Any ideas how to do this?