Prev: EQUIVALENT for this FORMULA , please
Next: How do u sort many items out a spread sheet in excel
From: Paula on 3 Jul 2008 14:40
This is the formula I put in:
=if(L42<3,"$50",if(L42>2<5,"$100")). Instead of returning $50 or $100 it
returns FALSE. What am I doing wrong?

Thank You.
From: Gary Brown on 3 Jul 2008 14:47
The 2nd If( ) function has some issues.
I THINK you mean...
=if(L42<3,"$50",if(and(L42>2,L42<5),"$100","$0"))
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"Paula" wrote:

> This is the formula I put in:
> =if(L42<3,"$50",if(L42>2<5,"$100")). Instead of returning $50 or $100 it
> returns FALSE. What am I doing wrong?
>
> Thank You.
From: Mike H on 3 Jul 2008 14:48
Paula

=IF(L42<3,"$50",IF(AND(L42>2,L42<5),"$100",""))

Mike

"Paula" wrote:

> This is the formula I put in:
> =if(L42<3,"$50",if(L42>2<5,"$100")). Instead of returning $50 or $100 it
> returns FALSE. What am I doing wrong?
>
> Thank You.
From: Dave Peterson on 3 Jul 2008 15:09
One more:

=IF(L42<3,50,IF(L42<5,100,""))

I don't see a reason to check for > 2 and < 5 in that second if().

And I changed the text to real numbers.


Paula wrote:
>
> This is the formula I put in:
> =if(L42<3,"$50",if(L42>2<5,"$100")). Instead of returning $50 or $100 it
> returns FALSE. What am I doing wrong?
>
> Thank You.

--

Dave Peterson
From: Paula on 3 Jul 2008 15:22
I put in this, the number in K5 is 10, so according to this formula should
return $260, but will not return anything. What ever I put in the last
quotation marks, that is what it returns. Any suggestions? The actual
formula will have 11 parts, where this example only has 4 parts.

=IF(K5<3,"$50",IF(AND(K5>2<6),"$100",IF(AND(K5>5<9),"$180",IF(AND(K5>8<13),"$260",""))))

"Mike H" wrote:

> Paula
>
> =IF(L42<3,"$50",IF(AND(L42>2,L42<5),"$100",""))
>
> Mike
>
> "Paula" wrote:
>
> > This is the formula I put in:
> > =if(L42<3,"$50",if(L42>2<5,"$100")). Instead of returning $50 or $100 it
> > returns FALSE. What am I doing wrong?
> >
> > Thank You.
 |  Next  |  Last
Pages: 1 2 3
Prev: EQUIVALENT for this FORMULA , please
Next: How do u sort many items out a spread sheet in excel