Confused about setting up functions based on variables?
 

I have 7 lines of data, with 2 variables each. if variable #1 is solo the i
need exel to produce sentence "A" with variable #2 in it. If variable #1 is
= to another variable #1 then I need excel to produce sentence "B" with the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. I will try to explain better
if I get a response.

Confused about setting up functions based on variables?
 

Perhaps you could give us an example and your formula.

Tyro

"NotExcelingNow" wrote in message
...
I have 7 lines of data, with 2 variables each. if variable #1 is solo the
i
need exel to produce sentence "A" with variable #2 in it. If variable #1
is
= to another variable #1 then I need excel to produce sentence "B" with
the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. I will try to explain
better
if I get a response.

Confused about setting up functions based on variables?
 

Please give further details, with examples of what you have and what
you want to achieve.

Pete

On Jan 9, 4:48*pm, NotExcelingNow
wrote:
I have 7 lines of data, with 2 variables each. *if variable #1 is solo the i
need exel to produce sentence "A" with variable #2 in it. *If variable #1 is
= to another variable #1 then I need excel to produce sentence "B" with the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. *I will try to explain better
if I get a response.

Confused about setting up functions based on variables?
 

Days Strength
7 (H40) 1000(N40) I need it to display 1000
when 41-43 are
14 (H41) 2000(N41) not there, 2000 when 42-43
are not there
28 (H42) 3000(N42) and avg 42 & 43 when all
are there. the
28 (H43) 4000(N43) problem is I need it to
refrence the 7, 14,
28 numbers, not
the cells, as the cell
order may change

The number of days changes I might have 3, 7, 14, 28, 28, 28, 56
so I need it to list the strength from the individual days and avg the 28s,
or any other day that may have multiple data. The most days I will have
would be 7.

Can you do an "if" inside another "if"?

=AND(N$40<0,N$41<0,N$42<0,N$43=0,N$44=0,N$45=0, N46=0)<<<<M59

=ROUND((IF(H42=H41,H40=H41),AVERAGE(P40:Q42),(IF(H 41=H42,AVERAGE(P41:Q42),(P42))),0)

"Pete_UK" wrote:

Please give further details, with examples of what you have and what
you want to achieve.

Pete

On Jan 9, 4:48 pm, NotExcelingNow
wrote:
I have 7 lines of data, with 2 variables each. if variable #1 is solo the i
need exel to produce sentence "A" with variable #2 in it. If variable #1 is
= to another variable #1 then I need excel to produce sentence "B" with the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. I will try to explain better
if I get a response.

Confused about setting up functions based on variables?
 

I'm sorry, but this still makes no sense to me - perhaps someone else
can understand what you want to do.

Pete

On Jan 9, 6:56*pm, NotExcelingNow
wrote:
Days * * * * * * * * * *Strength
7 * (H40) * * * * * * * *1000(N40) * * * * * * * * I need it to display 1000
when 41-43 are
14 (H41) * * * * * * * *2000(N41) * * * * * * * * not there, 2000 when 42-43
are not there
28 (H42) * * * * * * * *3000(N42) * * * * * * * * and avg 42 & 43 when all
are there. *the
28 (H43) * * * * * * * *4000(N43) * * * * * * * * problem is I need it to
refrence the 7, 14,
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *28 numbers, not
the cells, as the cell
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *order may change

The number of days changes I might have 3, 7, 14, 28, 28, 28, 56
so I need it to list the strength from the individual days and avg the 28s,
or any other day that may have multiple data. *The most days I will have
would be 7.

Can you do an "if" inside another "if"?

=AND(N$40<0,N$41<0,N$42<0,N$43=0,N$44=0,N$45=0, N46=0)<<<<M59

=ROUND((IF(H42=H41,H40=H41),AVERAGE(P40:Q42),(IF(H 41=H42,AVERAGE(P41:Q42),(*P42))),0)



"Pete_UK" wrote:
Please give further details, with examples of what you have and what
you want to achieve.

Pete

On Jan 9, 4:48 pm, NotExcelingNow
wrote:
I have 7 lines of data, with 2 variables each. *if variable #1 is solo the i
need exel to produce sentence "A" with variable #2 in it. *If variable #1 is
= to another variable #1 then I need excel to produce sentence "B" with the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. *I will try to explain better
if I get a response.- Hide quoted text -

- Show quoted text -

Confused about setting up functions based on variables?
 

is there any way to post the excel sheet so I can show you, it is real hard
to explain.

If there is only 1 of a certain day strength I need it to say "The __ day
strength is __% of design
If there is more than 1 strength for the same day I need it to avg the
strength and say "the avg ___day strength is ___% of design.
There are 7 rows of info, and two column variables. The columns are where
the prob is. I cant refrence the cell #s because the Cells with the same
Days in them may not always be in the same order. Ex: 2,14,28,28,28,56 or
3, 28,28,28, 56
So I am trying to get the "IF" formula to avg the cells with the same days,
or just list the strength if there is only one for that day.

Can you do an "IF" inside another "IF"?

"Pete_UK" wrote:

I'm sorry, but this still makes no sense to me - perhaps someone else
can understand what you want to do.

Pete

On Jan 9, 6:56 pm, NotExcelingNow
wrote:
Days Strength
7 (H40) 1000(N40) I need it to display 1000
when 41-43 are
14 (H41) 2000(N41) not there, 2000 when 42-43
are not there
28 (H42) 3000(N42) and avg 42 & 43 when all
are there. the
28 (H43) 4000(N43) problem is I need it to
refrence the 7, 14,
28 numbers, not
the cells, as the cell
order may change

The number of days changes I might have 3, 7, 14, 28, 28, 28, 56
so I need it to list the strength from the individual days and avg the 28s,
or any other day that may have multiple data. The most days I will have
would be 7.

Can you do an "if" inside another "if"?

=AND(N$40<0,N$41<0,N$42<0,N$43=0,N$44=0,N$45=0, N46=0)<<<<M59

=ROUND((IF(H42=H41,H40=H41),AVERAGE(P40:Q42),(IF(H 41=H42,AVERAGE(P41:Q42),(Â*P42))),0)



"Pete_UK" wrote:
Please give further details, with examples of what you have and what
you want to achieve.

Pete

On Jan 9, 4:48 pm, NotExcelingNow
wrote:
I have 7 lines of data, with 2 variables each. if variable #1 is solo the i
need exel to produce sentence "A" with variable #2 in it. If variable #1 is
= to another variable #1 then I need excel to produce sentence "B" with the
avg of coresponding variable #2s
I almost have it working, I just cant get it to avg variable #2s based on
coresponding variable #1s

Im sorry if this is asked in a confusing way. I will try to explain better
if I get a response.- Hide quoted text -

- Show quoted text -