PC Review


Reply
Thread Tools Rate Thread

Comparing cells with text to cells with numeric values.

 
 
David B
Guest
Posts: n/a
 
      25th Apr 2008
I am manually entering an abrv. day of the week in one cell and need to
compare that to a formula generated day of the week in another cell in a what
if statement. At this point I have been unable to figure out how to make the
two cells communicate.
--
David B
 
Reply With Quote
 
 
 
 
Joel
Guest
Posts: n/a
 
      25th Apr 2008
This will return a three character abbreveation using any date

WeekdayName(Weekday(DateValue("4/25/08")), abbreviate:=True)

"David B" wrote:

> I am manually entering an abrv. day of the week in one cell and need to
> compare that to a formula generated day of the week in another cell in a what
> if statement. At this point I have been unable to figure out how to make the
> two cells communicate.
> --
> David B

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing cells written in text to cells producing text from a for David B Microsoft Excel Programming 1 28th Apr 2008 07:20 PM
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row Sam via OfficeKB.com Microsoft Excel Worksheet Functions 5 9th Feb 2008 03:07 AM
Comparing Values from 2 cells =?Utf-8?B?UmVnZ2ll?= Microsoft Excel Programming 2 13th Dec 2005 07:51 PM
Iterating through cells, comparing values kingpin2502 Microsoft Excel Programming 0 11th Jul 2005 06:08 PM
Comparing values in non contigious cells thePriest Microsoft Excel Programming 3 3rd Mar 2005 05:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:09 AM.