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 ?
|