Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie

Try this, then, Connie, entered in N54:

=IF(C54="PL",N3,IF(C54="ST",N6,IF(C54="PR",N9,"non e")))

This returns "none" if none of the criteria are met - you might like to
make it "" or 0, depending on what you want to do in this situation.

Hope this helps.

Pete

Another way

=(C54="PL")*N3+(C54="ST")*N6+(C54="PR")*N9


"Connie Martin" wrote:

Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie

In both of these formulas, what they are giving is the exact same value in
N3, N6 and N9. N3, N6 and N9 are formulas of =SUM which need to calculate
the cells to the left of N54, which should return a different value based on
what's in the cells to the left. Hope that is a little clearer!

Connie

"Connie Martin" wrote:

Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie

Not the least bit clearer. The formulas given you EXACTLY met your first
statement of the problem. Now you say that's not really the problem and
offer this new tidbit below. However, this extra info just seems to cloud
things up for me.

Let's try again with a clear, concise statement of the issue, please


"Connie Martin" wrote:

In both of these formulas, what they are giving is the exact same value in
N3, N6 and N9. N3, N6 and N9 are formulas of =SUM which need to calculate
the cells to the left of N54, which should return a different value based on
what's in the cells to the left. Hope that is a little clearer!

Connie

"Connie Martin" wrote:

Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie

Let's hope that this is the more clear statement:

Attempting to bring in a calculation formula of =sum(****) into a cell
below, if C54 = PR it will bring in one calculation formula located in cell
N9, but if C54 = PL it will bring in another calculation formula located in
cell N3, but if C54 is =ST it will bring in yet another calculation formula
located in cell N6.

so for example...
PR would bring in calcuation formula from N9 which would be
=sum(T3*G3*j3) but...
ST would bring in calculation formula from N6 which would be
=sum(T3*g3) and
PL would bring in calculation formula =sum(t3*g3)

"Duke Carey" wrote:

Not the least bit clearer. The formulas given you EXACTLY met your first
statement of the problem. Now you say that's not really the problem and
offer this new tidbit below. However, this extra info just seems to cloud
things up for me.

Let's try again with a clear, concise statement of the issue, please


"Connie Martin" wrote:

In both of these formulas, what they are giving is the exact same value in
N3, N6 and N9. N3, N6 and N9 are formulas of =SUM which need to calculate
the cells to the left of N54, which should return a different value based on
what's in the cells to the left. Hope that is a little clearer!

Connie

"Connie Martin" wrote:

Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie

Duke, I am doing this for someone else at the office. Perhaps I'm not
understanding it clearly enough, but the response just above from me, she
typed herself. If it still isn't clear, I think she will have to take over
and post herself.

Connie

"Duke Carey" wrote:

Not the least bit clearer. The formulas given you EXACTLY met your first
statement of the problem. Now you say that's not really the problem and
offer this new tidbit below. However, this extra info just seems to cloud
things up for me.

Let's try again with a clear, concise statement of the issue, please


"Connie Martin" wrote:

In both of these formulas, what they are giving is the exact same value in
N3, N6 and N9. N3, N6 and N9 are formulas of =SUM which need to calculate
the cells to the left of N54, which should return a different value based on
what's in the cells to the left. Hope that is a little clearer!

Connie

"Connie Martin" wrote:

Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie

You don't need the sum( ... ) part. If I understand you properly, this
will give you what you want:

=IF(C54="PL",T3*G3,IF(C54="ST",T3*G3,IF(C54="PR",T 3*G3*J3,"none")))

My earlier comments about "none" still apply. If your formulae above
are in N3, N6 and N9, however, I don't see why the earlier formula did
not work for you.

Hope this helps.

Pete

Pete, thank you for responding. I will pass this on to the other girl in the
office for whom I am posting this question, and if that is still not what
she's looking for, I will insist that she sign on and post herself. I agree
with you that the sum part is not needed. I think I know what she's trying
to do and, to me, she's doing it a complicated way. The formulas in N3, N6
and N9 have $ symbols in them and I think that's where her problem is, but
I'm going to have to bow out. She will have to post herself.

I just want to thank both you and Duke for attempting to answer this, and
you have answered well according to the info given you. I do not plan to
post again for another person because, unless I am personally working with
the spreadsheet, I can hardly do justice in explaining it here to this
newsgroup. It would be best she post her own question.

Connie

"Pete_UK" wrote:

You don't need the sum( ... ) part. If I understand you properly, this
will give you what you want:

=IF(C54="PL",T3*G3,IF(C54="ST",T3*G3,IF(C54="PR",T 3*G3*J3,"none")))

My earlier comments about "none" still apply. If your formulae above
are in N3, N6 and N9, however, I don't see why the earlier formula did
not work for you.

Hope this helps.

Pete

Pete, this appears to the answer she was looking for. It works. So, thank
you very much. Connie

"Pete_UK" wrote:

You don't need the sum( ... ) part. If I understand you properly, this
will give you what you want:

=IF(C54="PL",T3*G3,IF(C54="ST",T3*G3,IF(C54="PR",T 3*G3*J3,"none")))

My earlier comments about "none" still apply. If your formulae above
are in N3, N6 and N9, however, I don't see why the earlier formula did
not work for you.

Hope this helps.

Pete

Well, I'm glad we finally got something to work for you - thanks for
feeding back.

Pete