Comparing cells written in text to cells producing text from a for

's Computer Specifications

Example: I hand enter Tue in A1. From a dated data entry I format cell C1 to
reflect the day of the week an action occurred, and abrv the format ie: Wed.
I need to compare A1 Tue to C1 Wed and get a true or false answer. This will
let me calculate the number of on time deliveries vrs missed.

David B

's Computer Specifications

Try
=IF(A1=TEXT(B1,"ddd"),TRUE,FALSE)

Hope this helps,

Hutch

"David B" wrote:

> Example: I hand enter Tue in A1. From a dated data entry I format cell C1 to
> reflect the day of the week an action occurred, and abrv the format ie: Wed.
> I need to compare A1 Tue to C1 Wed and get a true or false answer. This will
> let me calculate the number of on time deliveries vrs missed.
>
>
> David B

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing Text to Several Cells	Pontus	Microsoft Excel Misc	4	4th Jul 2008 04:01 PM
Comparing cells with text to cells with numeric values.	David B	Microsoft Excel Programming	1	25th Apr 2008 08:05 PM
Comparing cells with text	Mortir	Microsoft Excel Worksheet Functions	3	3rd Jan 2007 09:40 PM
comparing text cells	=?Utf-8?B?Q29tYW5kZXI=?=	Microsoft Excel Worksheet Functions	2	5th Jun 2006 10:00 PM
Comparing Text Cells	Paul Moles	Microsoft Excel Worksheet Functions	1	10th Jan 2004 05:42 PM