Posted to microsoft.public.excel.misc

Savio

external usenet poster

Posts: 19

Comparison Formula

I have a day entered in cell E2, and i am trying to write a formula to
return "T" if E2 is any value from Monday-Friday and "F" if not.

=IF(E2=OR("Monday","Tuesday","Wednesday","Thursday ","Friday"),"T","F")

Could you tell me what's wrong with the above formula and how to
correct it.

thanks

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 Comparison Formula	Webtek	Excel Discussion (Misc queries)	0	March 28th 07 02:53 AM
Need Comparison Formula	ufo_pilot	Excel Discussion (Misc queries)	0	March 28th 07 01:59 AM
Need Comparison Formula	Max	Excel Discussion (Misc queries)	0	March 28th 07 01:16 AM
Comparison Formula	[email protected]	Excel Worksheet Functions	3	March 11th 06 02:55 AM
formula for comparison	sweetsue516	Excel Discussion (Misc queries)	2	August 31st 05 05:09 PM

All times are GMT +1. The time now is 07:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us