Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 8

Referencing several cells with IF?

I just wanted to know if there is a way that I can check the content of
several cells with a function (possibly IF) to return a value in A1 if the
cells referenced all have a specific value.

To clarify I want A1 to return text "R" if B1, C1, D1 and E1 all have dates
in them.

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
Referencing Cells	PAL	Excel Worksheet Functions	1	January 23rd 08 08:40 AM
Referencing Cells	PAL	Excel Worksheet Functions	0	January 23rd 08 01:20 AM
Referencing other cells	vfoley	Excel Discussion (Misc queries)	4	April 30th 07 05:30 PM
Referencing cells	cate	New Users to Excel	3	April 26th 06 08:34 PM
Referencing Cells	Bill W	Excel Worksheet Functions	0	August 4th 05 05:10 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us