Monster Formula

Hi All. I'm new to here, but I've been using excel for years. I am creating a worksheet to track my Girl Scout's awards. I have it all done EXCECT for one formula. I can't get it right. I'm going to TRY to explain this. The ( is the cell address) then number in front is the answer to adding columns elsewere.

ANSWER(a114) 2(b144) 1(c144) 0(d144) 1(e144) 1(f144) 1(g144)

OK I hope that makes since.

What I want it to do to answer "c" IF b=2, and between c, d, e, =2 BUT only 1 in each letter count, AND f=1 and g=1

IF not then it needs to answer "P" if the sum is >0 then it needs to answer a blank if all are 0.

For posters in general:
If you write out your problem as a flowchart I think you will probably be
able to solve it yourself. If you are not used to flowcharts:

____________
| Question |
___________
| Y | N | _______________| Next question|
____________
|
____________
| Next question |
____________

and so on ..

|
______
|action |
______


Simple techniques like this can help to clear the mind.

HTH you or somebody else.

"RobertaS54" <[email protected]> wrote
in message news:[email protected]...
>
> Hi All. I'm new to here, but I've been using excel for years. I am
> creating a worksheet to track my Girl Scout's awards. I have it all
> done EXCECT for one formula. I can't get it right. I'm going to TRY to
> explain this. The ( is the cell address) then number in front is the
> answer to adding columns elsewere.
>
> ANSWER(a114) 2(b144) 1(c144) 0(d144) 1(e144) 1(f144) 1(g144)
>
> OK I hope that makes since.
>
> What I want it to do to answer "c" IF b=2, and between c, d, e, =2 BUT
> only 1 in each letter count, AND f=1 and g=1
>
> IF not then it needs to answer "P" if the sum is >0 then it needs to
> answer a blank if all are 0.
>
>
> --
> RobertaS54
> ------------------------------------------------------------------------
> RobertaS54's Profile:
> http://www.excelforum.com/member.php...o&userid=37771
> View this thread: http://www.excelforum.com/showthread...hreadid=573468
>

RobertaS54,

Speaking personally I do not follow what it is you are asking. Can you try
to explain it again with perhaps an example or two with the result you want
returned.


--
Regards,

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"RobertaS54" <[email protected]> wrote
in message news:[email protected]...
>
> Hi All. I'm new to here, but I've been using excel for years. I am
> creating a worksheet to track my Girl Scout's awards. I have it all
> done EXCECT for one formula. I can't get it right. I'm going to TRY to
> explain this. The ( is the cell address) then number in front is the
> answer to adding columns elsewere.
>
> ANSWER(a114) 2(b144) 1(c144) 0(d144) 1(e144) 1(f144) 1(g144)
>
> OK I hope that makes since.
>
> What I want it to do to answer "c" IF b=2, and between c, d, e, =2 BUT
> only 1 in each letter count, AND f=1 and g=1
>
> IF not then it needs to answer "P" if the sum is >0 then it needs to
> answer a blank if all are 0.
>
>
> --
> RobertaS54
> ------------------------------------------------------------------------
> RobertaS54's Profile:
> http://www.excelforum.com/member.php...o&userid=37771
> View this thread: http://www.excelforum.com/showthread...hreadid=573468
>