Perform functions based on conditions met

Hi.
I would like to do the following:
- if condition A is met, it will perform forumla A; If B, formula B; and so on.
Eg: If a series of data has 5 numbers, it will check if the value is larger than
8. If 6, larger than 6.

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

Do you mean

=IF(A1="cond1",formula_A,If(A1="cond2",formula_B,...)) etc.

--
HTH

Bob Phillips

"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:%23vm5LesjFHA.2784@TK2MSFTNGP10.phx.gbl...
> Hi.
> I would like to do the following:
> - if condition A is met, it will perform forumla A; If B, formula B; and
so on.
> Eg: If a series of data has 5 numbers, it will check if the value is
larger than
> 8. If 6, larger than 6.
>
> --
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>

> Do you mean
>
> =IF(A1="cond1",formula_A,If(A1="cond2",formula_B,...)) etc.

Yes, correct.
So how to do?

Additional information:
- I'm using Office XP
- I'm using Windows XP


> --
> HTH
>
> Bob Phillips
>
> "0-0 Wai Wai ^-^" <x@x.com> wrote in message
> news:%23vm5LesjFHA.2784@TK2MSFTNGP10.phx.gbl...
> > Hi.
> > I would like to do the following:
> > - if condition A is met, it will perform forumla A; If B, formula B; and
> so on.
> > Eg: If a series of data has 5 numbers, it will check if the value is
> larger than
> > 8. If 6, larger than 6.
> >
> > --
> > Additional information:
> > - I'm using Office XP
> > - I'm using Windows XP
> >
> >
>
>

That was how to do it.

--
HTH

Bob Phillips

"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:OV7h6bujFHA.3316@TK2MSFTNGP14.phx.gbl...
>
> > Do you mean
> >
> > =IF(A1="cond1",formula_A,If(A1="cond2",formula_B,...)) etc.
>
> Yes, correct.
> So how to do?
>
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "0-0 Wai Wai ^-^" <x@x.com> wrote in message
> > news:%23vm5LesjFHA.2784@TK2MSFTNGP10.phx.gbl...
> > > Hi.
> > > I would like to do the following:
> > > - if condition A is met, it will perform forumla A; If B, formula B;
and
> > so on.
> > > Eg: If a series of data has 5 numbers, it will check if the value is
> > larger than
> > > 8. If 6, larger than 6.
> > >
> > > --
> > > Additional information:
> > > - I'm using Office XP
> > > - I'm using Windows XP
> > >
> > >
> >
> >
>
>

How silly I am!
Thanks for your answer.

> That was how to do it.
>
> --
> HTH
>
> Bob Phillips
>
> "0-0 Wai Wai ^-^" <x@x.com> wrote in message
> news:OV7h6bujFHA.3316@TK2MSFTNGP14.phx.gbl...
> >
> > > Do you mean
> > >
> > > =IF(A1="cond1",formula_A,If(A1="cond2",formula_B,...)) etc.
> >
> > Yes, correct.
> > So how to do?
> >
> > Additional information:
> > - I'm using Office XP
> > - I'm using Windows XP
> >
> >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "0-0 Wai Wai ^-^" <x@x.com> wrote in message
> > > news:%23vm5LesjFHA.2784@TK2MSFTNGP10.phx.gbl...
> > > > Hi.
> > > > I would like to do the following:
> > > > - if condition A is met, it will perform forumla A; If B, formula B;
> and
> > > so on.
> > > > Eg: If a series of data has 5 numbers, it will check if the value is
> > > larger than
> > > > 8. If 6, larger than 6.
> > > >
> > > > --
> > > > Additional information:
> > > > - I'm using Office XP
> > > > - I'm using Windows XP
> > > >
> > > >
> > >
> > >
> >
> >
>
>