How to refer to a data in a cell where the value is a formula

[crapit]

as above

[sweet_dreams]

if you want to use value form the cell you simply have to give it's
address. it doesn't matter if there is a formula in cell or not

sweet_dreams

[crapit]

I'm using it in conditional format. Cells custom format to "DDD" (w/o
quote)

A1 = 23/01/06 which give "MON"
B1 = A1 + 1 which give "TUE"
B2 using conditional formatting =B1="Tue", cell shading color = red

A B C
1 MON TUE
2
3


"sweet_dreams" <sweet_dreams@o2.pl> wrote in message
news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> if you want to use value form the cell you simply have to give it's
> address. it doesn't matter if there is a formula in cell or not
>
> sweet_dreams
>

[Dave Peterson]

The value in the cell and what you see are two different things--especially with
dates (and numbers (like money)).

If you want to check to see if a date is a Tuesday:

=WEEKDAY(A1,2)=2

(Check excel's help for =weekday() and you'll see that that ",2" means start
counting with Monday = 1.



crapit wrote:
>
> I'm using it in conditional format. Cells custom format to "DDD" (w/o
> quote)
>
> A1 = 23/01/06 which give "MON"
> B1 = A1 + 1 which give "TUE"
> B2 using conditional formatting =B1="Tue", cell shading color = red
>
> A B C
> 1 MON TUE
> 2
> 3
>
> "sweet_dreams" <sweet_dreams@o2.pl> wrote in message
> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> > if you want to use value form the cell you simply have to give it's
> > address. it doesn't matter if there is a formula in cell or not
> >
> > sweet_dreams
> >

--

Dave Peterson

[crapit]

What I want to ck is to see whether tat particular cell B1 = sun, since that
cell value is an evaluation, I dont know how to determine it!

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43D4EACF.157C4475@verizonXSPAM.net...
> The value in the cell and what you see are two different
> things--especially with
> dates (and numbers (like money)).
>
> If you want to check to see if a date is a Tuesday:
>
> =WEEKDAY(A1,2)=2
>
> (Check excel's help for =weekday() and you'll see that that ",2" means
> start
> counting with Monday = 1.
>
>
>
> crapit wrote:
>>
>> I'm using it in conditional format. Cells custom format to "DDD" (w/o
>> quote)
>>
>> A1 = 23/01/06 which give "MON"
>> B1 = A1 + 1 which give "TUE"
>> B2 using conditional formatting =B1="Tue", cell shading color = red
>>
>> A B C
>> 1 MON TUE
>> 2
>> 3
>>
>> "sweet_dreams" <sweet_dreams@o2.pl> wrote in message
>> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
>> > if you want to use value form the cell you simply have to give it's
>> > address. it doesn't matter if there is a formula in cell or not
>> >
>> > sweet_dreams
>> >
>
> --
>
> Dave Peterson

[Dave Peterson]

If you look at excel's help for =weekday(), you'll find one way:

=weekday(a1,1)=1
or
=weekday(a1,2)=7



crapit wrote:
>
> What I want to ck is to see whether tat particular cell B1 = sun, since that
> cell value is an evaluation, I dont know how to determine it!
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:43D4EACF.157C4475@verizonXSPAM.net...
> > The value in the cell and what you see are two different
> > things--especially with
> > dates (and numbers (like money)).
> >
> > If you want to check to see if a date is a Tuesday:
> >
> > =WEEKDAY(A1,2)=2
> >
> > (Check excel's help for =weekday() and you'll see that that ",2" means
> > start
> > counting with Monday = 1.
> >
> >
> >
> > crapit wrote:
> >>
> >> I'm using it in conditional format. Cells custom format to "DDD" (w/o
> >> quote)
> >>
> >> A1 = 23/01/06 which give "MON"
> >> B1 = A1 + 1 which give "TUE"
> >> B2 using conditional formatting =B1="Tue", cell shading color = red
> >>
> >> A B C
> >> 1 MON TUE
> >> 2
> >> 3
> >>
> >> "sweet_dreams" <sweet_dreams@o2.pl> wrote in message
> >> news:1138017127.286822.27280@o13g2000cwo.googlegroups.com...
> >> > if you want to use value form the cell you simply have to give it's
> >> > address. it doesn't matter if there is a formula in cell or not
> >> >
> >> > sweet_dreams
> >> >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson