Need to find a function.

[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

 

[Guest]

Try

=IF(F13<0,"2 Complex",IF(F13=0,"1 Rational",IF(MOD(SQRT(F13),1),"2
Irrational","2 Rational")))

 

[Guest]

Thank you. That seems to have done the trick.