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

I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

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


"JcR" wrote:

I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

Hi!

Try removing the quotes from around your numbers:

=IF(d250,50,IF(d225,25,IF(d2<26,a2)))

Biff

"JcR" wrote in message
...
I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

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(d250,50,IF(d225,25,a2)))

George

JcR wrote:
I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

thanks

"Biff" wrote:

Hi!

Try removing the quotes from around your numbers:

=IF(d250,50,IF(d225,25,IF(d2<26,a2)))

Biff

"JcR" wrote in message
...
I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

thanks

"George" wrote:

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(d250,50,IF(d225,25,a2)))

George

JcR wrote:
I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

thanks

"MarkN" wrote:

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


"JcR" wrote:

I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?

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

You're welcome!

Biff

"JcR" wrote in message
...
thanks

"Biff" wrote:

Hi!

Try removing the quotes from around your numbers:

=IF(d250,50,IF(d225,25,IF(d2<26,a2)))

Biff

"JcR" wrote in message
...
I have a formula in e2 that goes like this:
=IF(d250,"50",IF(d225,"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 ?