Error: Excel doe’snt recognise the formula and tells me to start it with “=” sign
I am establishing a blood electrolytes data analysis using Excel .
I entered the following formula to classify the result of calcium but Excel would not accept it and tells me it is text and should start it with “=” sign.,
The formula is:
=IF(H10<2.2),”Low”),IF(H10=>2.2,H10=<2.55),””,IF(H1>2.55,H10=<2.61975),”Mild Hypercalcemia”,IF(H10=<3.46905,”Moderate Hypercalcemia”,IF(H10>3.46705,”HYPERCALCEMIC CRISES”,””))))
Can anybody help.
Sincere thanks in advance
Ibrahim
I am establishing a blood electrolytes data analysis using Excel .I entered the following formula to classify the result of calcium but Excel would not accept it and tells me it is text and should start it with “=” sign.,The formula is: =IF(H10<2.2),”Low”),IF(H10=>2.2,H10=<2.55),””,IF(H1>2.55,H10=<2.61975),”Mild Hypercalcemia”,IF(H10=<3.46905,”Moderate Hypercalcemia”,IF(H10>3.46705,”HYPERCALCEMIC CRISES”,””)))) Can anybody help.Sincere thanks in advanceIbrahim Read More
