Hereâs how the formula works: 1  We start with the same logical test to determine if a negative value exists using the MIN function. 2  A second IF function is then used to determine if the change from old to new is positive or negative. IF((new value â old value)>0,âPâ,âNâ)
Medicaid is a joint federal/state health insurance program providing medical care benefits to low income Americans who meet certain requirements. Nursing home care is covered through Medicaid, but the requirements and covered services vary widely from state to state.
Long-term care insurance policies may pay for several types of care, including. 1  Nursing home care in a licensed nursing home. 2  Assisted living care in a licensed assisted living home. 3  Home health care services provided by a licensed home health agency. Services may include skilled nursing care and physical therapy.