IF(....)=13,"your reference",(...the rest) without quotes (or if it will be a text - with quotes
)
try
but formula counting like I said before: 1-12 and blank, where now blank is your reference and show result of C12*U5
without any example I can't say more because I don't see how you organize you worksheet
btw. with
mehmetcik's formula you can do the same: =IF(MOD(ROWS(A$1:A1),13)=0,
"your reference",C12*US)
you need to know what are you doing with "red" part of formulas.
I reading very fast and lost it, sorry
with
mehmetcik's, (
modified) formula, again (
thanks mehmetcik )
=IF(MOD(COLUMN(A$1),13)=0,
"reference",$C12*U$5) and drag it to the right
or
and drag to the right also.
Bookmarks