Re: Nested If statement
- From: <Andy>
- Date: Thu, 30 Jun 2005 22:19:22 +0100
Hi
Try this:
=IF(AND(AR5=0,AT5=0),(10/1*AW5)+(10/3*1),IF(AR5=0,(10/3*AW5)+(10/3*1),(10/5*AW5)+(10/5*1)))
Andy.
"rsbergeron" <rsbergeron.1rgjmm_1120165622.9584@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:rsbergeron.1rgjmm_1120165622.9584@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I am trying to get this if statement to work, but I keep getting an
> error when I exit the cell. Please Help!
>
> =(IF(AR5=0 & AT5=0,(10/1*AW5)+(10/3*1),(if
> AR5=0,(10/3*AW5)+(10/3*1),(10/5*AW5)+(10/5*1))))
>
>
> --
> rsbergeron
> ------------------------------------------------------------------------
> rsbergeron's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=24817
> View this thread: http://www.excelforum.com/showthread.php?threadid=383708
>
.
- Prev by Date: SUMIF
- Next by Date: RE: Using Match function with duplicate values in an array
- Previous by thread: SUMIF
- Next by thread: RE: Using Match function with duplicate values in an array
- Index(es):
Relevant Pages
|
