possible to use IF to add formula?
I would like to compare every two consecutive cells in a column
and either fill in 0 or a formula, something like this: if (day(c2) = day(c1),fill in the formula "=r[-1]c + 1", else fill in zero)--------this sould operate on D1 then copy & paste all the way to d1225. Can this be done? |
possible to use IF to add formula?
You won't be able to do this in D1, as you can't refer to the row
above, so put this formula in D2: =IF(DAY(C2)=DAY(C1),C1+1,0) Then select D2 again and copy the formula down by double-clicking the fill handle (the small black square in the bottom right corner of the cursor. Hope this helps. Pete On Aug 3, 2:26 am, John Smith wrote: I would like to compare every two consecutive cells in a column and either fill in 0 or a formula, something like this: if (day(c2) = day(c1),fill in the formula "=r[-1]c + 1", else fill in zero)--------this sould operate on D1 then copy & paste all the way to d1225. Can this be done? |
All times are GMT +1. The time now is 09:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com