equals the actual number...not text ????

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JcR - 16 Mar 2006 04:50 GMT

I have a formula in e2 that goes like this:
=IF(d2>50,"50",IF(d2>25,"25",IF(d2<26,a2)))

d2=b2*c2
a2 would be a number between 1 and 150

then i want to put the greater of a2 and e2 into f2
and writing like this =max(a2,e2)

it won't select the value in e2, it always elects value in a2

how can i fix ?

Reply to this Message

MarkN - 16 Mar 2006 05:27 GMT

I think that if you look at your IF function and remove the double inverted
commas from the numbers ie. =IF(d2>50,50,IF(d2>25,25,IF(d2<26,a2))), then it
should work.

Signature

Hope this helps,
MarkN

> I have a formula in e2 that goes like this:
> =IF(d2>50,"50",IF(d2>25,"25",IF(d2<26,a2)))
[quoted text clipped - 8 lines]
>
> how can i fix ?

Reply to this Message

JcR - 16 Mar 2006 05:59 GMT

thanks

> I think that if you look at your IF function and remove the double inverted
> commas from the numbers ie. =IF(d2>50,50,IF(d2>25,25,IF(d2<26,a2))), then it
[quoted text clipped - 12 lines]
> >
> > how can i fix ?

Reply to this Message

Biff - 16 Mar 2006 05:27 GMT

Hi!

Try removing the quotes from around your numbers:

=IF(d2>50,50,IF(d2>25,25,IF(d2<26,a2)))

Biff

>I have a formula in e2 that goes like this:
> =IF(d2>50,"50",IF(d2>25,"25",IF(d2<26,a2)))
[quoted text clipped - 8 lines]
>
> how can i fix ?

Reply to this Message

JcR - 16 Mar 2006 05:59 GMT

thanks

> Hi!
>
[quoted text clipped - 16 lines]
> >
> > how can i fix ?

Reply to this Message

Biff - 16 Mar 2006 06:10 GMT

You're welcome!

Biff

> thanks
>
[quoted text clipped - 18 lines]
>> >
>> > how can i fix ?

Reply to this Message

George - 16 Mar 2006 05:29 GMT

Remove the quotes from the 50 and 25, you are entering them as text not
as number
Also you can lose the last if statement
=IF(d2>50,50,IF(d2>25,25,a2)))

George

> I have a formula in e2 that goes like this:
> =IF(d2>50,"50",IF(d2>25,"25",IF(d2<26,a2)))
[quoted text clipped - 8 lines]
>
> how can i fix ?

Reply to this Message

JcR - 16 Mar 2006 05:59 GMT

thanks

> Remove the quotes from the 50 and 25, you are entering them as text not
> as number
[quoted text clipped - 15 lines]
> >
> > how can i fix ?

Reply to this Message