Formula needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,"none")))

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
 
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
 
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
 
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, 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
 
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",T3*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, this appears to the answer she was looking for. It works. So, thank
you very much. Connie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Problem with Excel 0
Conditional if formula. 5
Number Lookup in Matrix 12
Average of difference between dates greater than zero 8
sum a row, but just the cells, where there is a number. 1
Nested IF Function problem for Excel 2003 7
countif adding AND 13
SUMPRODUCT with LEFT() criteria? 5

Back
Top