G
Guest
I am working on a function to help with finding solutions to quadratic
equations so I can help kids in (pre-)algebra as a voulenteer past my work as
a sysadmin. The current formula looks something like this:
=IF(F13<0,"2 Complex",IF(F13=0,"1
Rational",IF(AND(F13>0,OR(ISEVEN(SQRT(F13)),ISODD(SQRT(F13)))),"2
Rational","2 Irrational")))
the "ISEVEN(SQRT(F13)),ISODD(SQRT(F13))" does not do what I was hoping for.
It needs to be set so that if the result of SQRT(F13) is a whole number the
final result is "2 Rational" and if it is a integer with a decimal it returns
"2 irrational"
any help here is most appreciated
equations so I can help kids in (pre-)algebra as a voulenteer past my work as
a sysadmin. The current formula looks something like this:
=IF(F13<0,"2 Complex",IF(F13=0,"1
Rational",IF(AND(F13>0,OR(ISEVEN(SQRT(F13)),ISODD(SQRT(F13)))),"2
Rational","2 Irrational")))
the "ISEVEN(SQRT(F13)),ISODD(SQRT(F13))" does not do what I was hoping for.
It needs to be set so that if the result of SQRT(F13) is a whole number the
final result is "2 Rational" and if it is a integer with a decimal it returns
"2 irrational"
any help here is most appreciated