| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
And Question, (a&b, or just a)
Hi, I am trying to save some space, ~30% 1 column, cant tell if there is a
short way. short example: =IF(S9="","",IF(X1="c",AND(AND(A1="a",B1="b"),AND( C1="c",D1="d")),AND(A1="a",B1="b"))) if x=1, then part a & b, otherwise, just a. This works, but can't see how to just do with 2 parts, stead of part a repeated twice. just cannot see it... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) | |||
| Benefits many people - Question | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Threaded Mode
