Oops!

You were testing for 0 and I wrote the formula testing for blank!

Just change ="" to =0.

An empty cell evaluates to 0 so the formula will still return blank.

Biff

"Biff" <biffinpitt@comcast.net> wrote in message
news:%23%23%23C204XGHA.4144@TK2MSFTNGP04.phx.gbl...
> Hi!
>
> Try this:
>
> =IF(OFFSET(WorkSheet!C$10,(ROWS($1:1)-1)*12,,)="","",OFFSET(WorkSheet!C$12,(ROWS($1:1)-1)*12,,))
>
> Biff
>
> "MartinW" <mt@bigpond.invalid> wrote in message
> news:%23UnRag3XGHA.196@TK2MSFTNGP04.phx.gbl...
>> Hi Group,
>>
>>
>>
>> I have 2 sheets. One called WORKSHEET one called REPORT.
>>
>> In the report sheet I want to copy a formula down the page so
>>
>> that the referenced cells increment by 12 instead of 1 as per
>>
>> below.
>>
>>
>>
>> C18 =IF(WORKSHEET!C10=0,"",WORKSHEET!C12)
>>
>> C19 =IF(WORKSHEET!C22=0,"",WORKSHEET!C24)
>>
>> C20 =IF(WORKSHEET!C34=0,"",WORKSHEET!C36)
>>
>>
>>
>> I feel like this should be very simple but I just can't work it out,
>>
>> Any help would be much appreciated.
>>
>
>