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?