Posted to microsoft.public.excel.programming

Fester[_2_] Fester[_2_] is offline

external usenet poster

Posts: 12

Formula based on another cell value

I want to run a loop that looks at a value in one cell, and then
enters one formula for one value, and another for a different value.

So if Cell B2="X" then
range("E2").value = "formula"
elseif Cell B2 = "Y" then
range("E2").value = "other formula

this would loop through all cells until it found an empty cell.

Any help is appreciated.

Brendon

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
Add Cell range based on color of cell to existing formula	Jul in Ohio	Excel Programming	2	July 30th 07 02:18 PM
Change cell formula based on input in different cell	DtTall	Excel Programming	4	November 16th 06 10:34 AM
formula for named cell/range based on cell values	alex	Excel Programming	2	August 25th 05 02:50 PM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	1	February 11th 05 06:36 AM
Cell Formula reference to cell Based On third Cell Content	Gabriel	Excel Discussion (Misc queries)	0	February 11th 05 05:35 AM

All times are GMT +1. The time now is 12:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us