Thread: calculating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
justlearnin justlearnin is offline
external usenet poster
 
Posts: 14
Default calculating

I am making a telephone bill spreadsheet. I have the look the way I want it,
easy for employees to read. The thing is that with well over 150 employees, I
don't like to have to find ext and names every time I do this sheet. What I
would like to do, since the extention is there, do something like "if ext # =
106, name = Rose" for all of the employees. This way I can code it once and
reuse it, only having to modify new people. How do I do this?