# Search:

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

Page 1 of 7 1

1. ## Thread: week to date percent to goal

by cvbs
Replies
5
Views
177

### [SOLVED] RG, Thank You !!! It is excellent !!! ...

RG,

Thank You !!! It is excellent !!! Thanks for the perseverance ;) YOU are the man. Very much appreciated.

cvbs
2. ## Thread: week to date percent to goal

by cvbs
Replies
5
Views
177

### [SOLVED] RG, Thanks for the reply. I see that your...

RG,

Thanks for the reply. I see that your formula does work w/o problem if there are no merged cells, however that is something that I can not change w/in this sheet. The results keep coming...
3. ## Thread: week to date percent to goal

by cvbs
Replies
5
Views
177

### [SOLVED] week to date percent to goal

Good Morning all,

I am in need of creating a if then formula that will give me a w.t.d. % to goal.

I have attached a sheet w/ data filled in through Wed. I want to be able show the % of...
4. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

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

Steve, RG

Thanks... That works great... Sorry for all the confusion!! :D :clapping:
5. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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 ,...
6. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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 ...

...
7. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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...
8. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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...
9. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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...
10. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

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

Thank you again .... I appreciate the tip and will use it going forward!:D
11. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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...
12. ## Thread: what am I missing?

by cvbs
Replies
21
Views
685

### 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...

by cvbs
Replies
13
Views
859

### 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...

by cvbs
Replies
13
Views
859

### 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...

by cvbs
Replies
13
Views
859

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

Steve,

Lets try this.
Thanks

by cvbs
Replies
13
Views
859

### 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.

by cvbs
Replies
13
Views
859

### 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,...

by cvbs
Replies
13
Views
859

### 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...

by cvbs
Replies
13
Views
859

### 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...

by cvbs
Replies
3
Views
752

### 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...
21. ## Thread: solve for x ?

by cvbs
Replies
7
Views
771

### 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....

by cvbs
Replies
3
Views
605

### many thanks

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

by cvbs
Replies
3
Views
605

### 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...
24. ## Thread: displaying max number

by cvbs
Replies
7
Views
1,047

### 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????
25. ## Thread: displaying max number

by cvbs
Replies
7
Views
1,047

### 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. ...
Results 1 to 25 of 166
Page 1 of 7 1