# Search:

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

Page 1 of 7 1

1. ## Thread: what am I missing?

by cvbs
Replies
21
Views
404

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

Steve, RG

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

by cvbs
Replies
21
Views
404

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

by cvbs
Replies
21
Views
404

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

by cvbs
Replies
21
Views
404

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

by cvbs
Replies
21
Views
404

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

by cvbs
Replies
21
Views
404

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

by cvbs
Replies
21
Views
404

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

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

by cvbs
Replies
21
Views
404

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

by cvbs
Replies
21
Views
404

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

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

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

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

Steve,

Lets try this.
Thanks

by cvbs
Replies
13
Views
617

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

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

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

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

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

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

### many thanks

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

by cvbs
Replies
3
Views
534

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

by cvbs
Replies
7
Views
970

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

by cvbs
Replies
7
Views
970

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

by cvbs
Replies
7
Views
970

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

by cvbs
Replies
7
Views
970

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

...