Search:

Type: Posts; User: cvbs; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    21
    Views
    455

    Steve, RG Thanks... That works great... Sorry...

    Steve, RG

    Thanks... That works great... Sorry for all the confusion!! :D :clapping:
  2. Replies
    21
    Views
    455

    Gentleman, Column A & B are the numbers that...

    Gentleman,

    Column A & B are the numbers that are given to me. Column "C", what last years sales were is what I am trying to determine. Steve, to your question as to what does the percentage ,...
  3. Replies
    21
    Views
    455

    Steve, It is column C (last years) sales I am...

    Steve,
    It is column C (last years) sales I am trying to get by using the reported (this years) sales numbers (column A) and the percent of increase or decrease that is shown in column B ...

    ...
  4. Replies
    21
    Views
    455

    trying again

    Sorry ... I did not see the advance ... add attachment paper clip

    I do appreciate all your help and please accept my apology for the error in posting and having you do all that work.

    Thank...
  5. Replies
    21
    Views
    455

    Sorry for the follow up here. however I am still...

    Sorry for the follow up here. however I am still not getting the results to come out to the percent that was given to me as the amount of change. Here is a pic of the formulas I have tried.

    Thank...
  6. Replies
    21
    Views
    455

    Steve, Thank you for the input.... what...

    Steve,

    Thank you for the input.... what would you recommend for the formula to use ... even if it was less than 100% or even negative. Is there a formula you would use that could work for ALL...
  7. Replies
    21
    Views
    455

    Thank you again .... I appreciate the tip and...

    Thank you again .... I appreciate the tip and will use it going forward!:D
  8. Replies
    21
    Views
    455

    Thank you both for the replies. A follow...

    Thank you both for the replies.

    A follow up to the "round". .. Was the original formula incorrect to get last years sales or is round used because we are looking for an already given...
  9. Replies
    21
    Views
    455

    what am I missing?

    Hell all,

    Attached is an excerpt of sheet I am working on and this one piece is driving me nuts. I realize it is not a far drive, however I would rather not be making it!!!

    I have a given...
  10. Replies
    13
    Views
    654

    scheduler

    Steve,

    The first should have the blank template, before anyone manually fills in anything (and without any of the information you are asking about. You may want to highlight those cells that you...
  11. Replies
    13
    Views
    654

    Steve, Oversight on my part in setting up...

    Steve,

    Oversight on my part in setting up the examples where the calcs were eliminated in the manual sheet. They should be there as they are shown in the computer and blank.

    My logic to...
  12. Replies
    13
    Views
    654

    Steve, My Bad... rough morning. Lets try...

    Steve,

    My Bad... rough morning.
    Lets try this.
    Thanks
  13. Replies
    13
    Views
    654

    sdckapr: Thanks for helping .... I am...

    sdckapr:

    Thanks for helping ....
    I am attaching the workbook as requested ... please let me know if you have any other questions.
  14. Replies
    13
    Views
    654

    The "blank" sheet "Associate Schedule for the...

    The "blank" sheet "Associate Schedule for the week" is the same as rows 30 thru 36. I have put hours to work in for Monday thru Wed. Manager hours will not be counted in total hours available,...
  15. Replies
    13
    Views
    654

    Sdckapr.... My apologies .... the cells starting...

    Sdckapr.... My apologies .... the cells starting with B31 through u36 will be filled in depending on the number of associates employed at that time. the cells that show data currently are manually...
  16. Replies
    13
    Views
    654

    Employee Scheduler

    Hello all,

    I am trying to create a sheet that will auto schedule associates based on their ranking in productivity and their availability.

    (ie) .. if Associate #1 is ranked #1 in...
  17. Replies
    3
    Views
    619

    Add drive /run software from that drive?

    Hello all,

    I have been given an older Dell Optiplex tower that has a very small c: hard drive. I wanted to download and install "open Office" to use. Once I got the information from the web...
  18. Thread: solve for x ?

    by cvbs
    Replies
    7
    Views
    668

    solve for x ?

    helllo all

    I was thinking that excel had a function that could do this but for the life of me I could not remember it so if it is not available I need a formula that would solve for the following....
  19. Thread: vblookup problem

    by cvbs
    Replies
    3
    Views
    550

    many thanks

    Thank you sdckapr .... much appreciated for the quick reply... this will make my day much better :cool:
  20. Thread: vblookup problem

    by cvbs
    Replies
    3
    Views
    550

    vblookup problem

    Good Afternoon all,

    Attached is a sheet that has an excerpt from a list that I am using the vblookup formula with and it is returning the wrong answer 2 times within the column. Please review...
  21. Replies
    7
    Views
    976

    is the >= (and the rest of the formula) to be...

    is the >= (and the rest of the formula) to be added to the front part??? or are you saying Start with the =vlookup and forget the portion I already have????
  22. Replies
    7
    Views
    976

    RG, Sorry .... to many things going on at...

    RG,

    Sorry .... to many things going on at once ...
    =if(b2>90,vlookup(t3,tables!a4:b6,2)*A10 in the cell A10 is the running total number of hours that the person worked so far this year. ...
  23. Replies
    7
    Views
    976

    explaing more !!

    Hi all.

    I am not sure if I have explained this well enough in the previous post.

    I want to ADD a function to the existing formula, but I do not know which or if there is one, to give the...
  24. Replies
    7
    Views
    976

    displaying max number

    Hello all,

    the following formula works great as is. However I want to add the max allowed number accordingly to be displayed if the multiplication results goes over that.






    ...
  25. Thread: add string??

    by cvbs
    Replies
    2
    Views
    437

    thanks pecoflyer... this will work !! much...

    thanks pecoflyer... this will work !! much appreciated :cool:
Results 1 to 25 of 163
Page 1 of 7 1 2 3 4