Posted to microsoft.public.excel.programming

karlo[_4_] karlo[_4_] is offline

external usenet poster

Posts: 1

conditional formulas

hi, would it be possible to have a cell that changes formulas dependin
on the result of a certain cell (without using Validationlist).

eg.

if Cell 1 = 1 Cell 2 would apply the formula A1+B2
and if Cell 1 = 2 Cell 2 would apply the formula E1+B2+C3

thanks a bunc

--
Message posted from http://www.ExcelForum.com

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
conditional formulas	Danno[_2_]	Excel Discussion (Misc queries)	5	October 16th 08 09:31 PM
Conditional Formulas	Lee	Excel Discussion (Misc queries)	0	March 10th 08 06:43 PM
Conditional Formulas	Craig Koon	Excel Worksheet Functions	0	August 24th 06 11:36 PM
conditional formulas	Beth104	Excel Worksheet Functions	3	March 8th 06 03:09 PM
How do I set up conditional formulas	craig	Excel Worksheet Functions	1	February 4th 06 09:45 PM

All times are GMT +1. The time now is 05:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us