Re: Logic command IF/OR
- From: "Mangesh Yadav" <mangesh.NOSPAMyadav@xxxxxxxxx>
- Date: Fri, 7 Oct 2005 17:49:30 +0530
Maybe if you explain what you want to do, then we could help. What you are
doing does not look possible by just looking at the formula.
Mangesh
"G_Chem" <G_Chem.1wj6mb_1128686708.12@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:G_Chem.1wj6mb_1128686708.12@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi,
>
> excel 97.
>
> I'm trying to use a logic command to call up a *<* sign depending on
> whether a result in one cell when subtracted from another gives me a
> negative value.
>
> =IF(B2="AD1", ((E2-$D$23)<$D$25,"<", " "), OR (B2="AD2",
> (E2-$F$23)<$F$25,"<", " "))
>
> The above formula gives me an error message, is it possible to do what
> i'm trying to do?
>
> TIA
>
> G
>
>
> --
> G_Chem
> ------------------------------------------------------------------------
> G_Chem's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24366
> View this thread: http://www.excelforum.com/showthread.php?threadid=474095
>
.
- Prev by Date: Re: Check Box Formatting ??
- Next by Date: Re: Pull information from one worksheet to another
- Previous by thread: Re: Check Box Formatting ??
- Next by thread: Re: Logic command IF/OR
- Index(es):
Relevant Pages
|
