Thread: Offset Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Offset Formula

I have the formula =IF(D6=0,A6,"") in D150. How can I use the Offset
feature so that in D151 the following formula would appear
=IF(D9=0,A9,"") etc etc in D152, D153

I just cannot get my head around Offset feature

Thanks