Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 208

Help with creating a function

Hi,

I need help with this function.

=IF(D2="text", "G2","0")

When I copy the formula to the cells below it changes the reference of the
logical test, which is great, but I also need it to change the reference cell
of the true result. So that when I copy it to the cell below it becomes:

=IF(D3="text", "G3","0")

Thanks,

Craig

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
Need help creating a function	chrspty	Excel Worksheet Functions	2	August 1st 08 04:48 PM
Creating a Function	Stu Gnu[_2_]	Excel Worksheet Functions	2	August 30th 07 11:47 AM
Creating a function	BeginnerRick	Excel Worksheet Functions	3	November 24th 06 09:12 PM
Need help creating a function	nander	Excel Discussion (Misc queries)	3	February 20th 06 04:57 AM
creating a function	NeilPoehlmann	Excel Discussion (Misc queries)	5	June 15th 05 08:08 PM

All times are GMT +1. The time now is 08:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us