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 ?