| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing cells written in text to cells producing text from a for
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comparing cells written in text to cells producing text from a for
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Text to Several Cells | Excel Discussion (Misc queries) | |||
| Comparing cells with text to cells with numeric values. | Excel Programming | |||
| Comparing cells with text | Excel Worksheet Functions | |||
| comparing text cells | Excel Worksheet Functions | |||
| Comparing text strings in cells | Excel Discussion (Misc queries) | |||
Linear Mode
