| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formula Question
I have the following Columns (A and B) with binary output (1 and 0), such
that A and B would not both contain 1 but both could contain 0. What formula would I use in column C that calculates % change between cells D1 and E1 only when there has been a 1 in A and followed by a 1 in B. See example: A B C 1 0 0.00% 1 0 0.00% 1 0 0.00% 0 0 0.00% 0 1 3.00% 0 1 0.00% 0 1 0.00% 1 0 0.00% 0 1 3.00% 0 1 0.00% Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional maybe IF question | Excel Discussion (Misc queries) | |||
| Conditional formatting formula question | Excel Discussion (Misc queries) | |||
| question about conditional sum | Excel Discussion (Misc queries) | |||
| Conditional Formula question | Excel Discussion (Misc queries) | |||
| conditional sum question | Excel Worksheet Functions | |||
Threaded Mode
