Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. -- RobertaS54 ------------------------------------------------------------------------ RobertaS54's Profile: http://www.excelforum.com/member.php...o&userid=37771 View this thread: http://www.excelforum.com/showthread...hreadid=573468 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monster Formula
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |