Need to find a function.
 

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(F130,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
--
Head of IT for Imports International
Head of IT for Omaha Memorial School

Need to find a function.
 

Try

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

"MikeCampbell" wrote:

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(F130,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
--
Head of IT for Imports International
Head of IT for Omaha Memorial School

Need to find a function.
 

Thank you. That seems to have done the trick.
--
Head of IT for Imports International
Head of IT for Omaha Memorial School


"daddylonglegs" wrote:

Try

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

"MikeCampbell" wrote:

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(F130,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
--
Head of IT for Imports International
Head of IT for Omaha Memorial School