Posted to microsoft.public.excel.worksheet.functions

Sean

external usenet poster

Posts: 454

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Offset formula	Joe_Hunt	Excel Worksheet Functions	2	August 29th 08 12:35 AM
Offset formula	SHELL	Excel Worksheet Functions	4	August 10th 08 03:37 AM
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul	RyGuy	Excel Worksheet Functions	2	September 28th 07 10:54 PM
Offset formula	jostlund	Excel Discussion (Misc queries)	4	May 23rd 07 04:01 PM
Offset formula	richy	Excel Worksheet Functions	8	January 6th 06 09:27 PM

All times are GMT +1. The time now is 04:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us