Prev: Excel 2007 AutoSaves
Next: Alternate row comparison
From: T. Valko on 26 Dec 2009 11:54
>Cell D51 contains a formula -> =TEXT(B51,"dddd")

Another one...

=IF(LEFT(D51)="S","No Hours Recorded","Charged")

--
Biff
Microsoft Excel MVP


"Umar" <Umar(a)discussions.microsoft.com> wrote in message
news:A2D91C43-8BBD-44E2-BDFA-BB83EEA51F7C(a)microsoft.com...
>I tried these to NO avail:
> Cell D51 contains a formula -> =TEXT(B51,"dddd")
>
> For Cell E51 I want to enter an IF condition based upon the Weekday value
> in
> Cell D51.
>
> So, here is what I have tried and I also have tried some other variations:
>
> 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged")
>
> 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged')
>
> All failed, could anyone pinpoint and corrected the typo?


First  |  Prev  | 
Pages: 1 2
Prev: Excel 2007 AutoSaves
Next: Alternate row comparison