Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

CRIB II Research and Temperature Unit Conversion in Spreadsheets

Learn about the CRIB II research and convert fictional temperatures between Celsius and Fahrenheit.

CRIB II and neonatal research

Parry, Tucker and Tarnow-Mordi published CRIB II in 2003 as a neonatal risk-adjustment model using five items. The score uses defined inputs and a published point system; its interpretation and performance depend on the population and clinical setting.

This page does not calculate CRIB II, assign neonatal risk or estimate an individual outcome. Neonatal assessment and treatment require the treating clinical team and properly validated tools. The original research is linked below.

A separate temperature conversion

The Celsius-to-Fahrenheit conversion is °F = 1.8 × °C + 32. In a fictional numerical example, 36.5 °C equals 97.7 °F. Conversion alone says nothing about an infant’s health or a model score.

The formula rejects temperatures below absolute zero and rounds to two decimal places. Measurements, units and clinical interpretation must always be checked in their actual context.

CelsiusFahrenheit
0 °C32 °F
36.5 °C97.7 °F
100 °C212 °F

Convert an example value

Enter a numeric Celsius temperature in B2. The result is a unit conversion, not a medical classification.

=IF(COUNT(B2)<>1,"Enter a numeric temperature",IF(B2< -273.15,"Below absolute zero",ROUND(B2*1.8+32,2)))

Try the example

Use the original values or change them to test your understanding.

Further reading