Posted to microsoft.public.excel.misc

external usenet poster

Posts: 347

Formula with blank cells

Excel 2007
In a cost spreed sheet I need to set up a formula that will allow me to
change one cell to effect three different cells;
If D3 = A, then E3 = the sum of C3 x E2, if D3 = G or S, then E3 must remain
blank

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Formula with blank cells	Sheeloo[_3_]	Excel Discussion (Misc queries)	1	February 26th 09 10:41 PM
Formula with blank cells	JLatham	Excel Discussion (Misc queries)	0	February 26th 09 10:39 PM
Formula To Keep Certain Cells Blank	Dave	Excel Worksheet Functions	7	May 7th 08 09:10 PM
Formula to sum blank cells	rldjda	Excel Worksheet Functions	2	March 23rd 08 06:29 AM
Formula Help: Add cells with certain text + cells that are blank	Nicole L.	Excel Worksheet Functions	3	February 27th 07 06:59 AM

All times are GMT +1. The time now is 08:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us