#### Dr Lingkan

##### New Member

Can anyone develop two separate Excel formulas to calculate cardiovascular risk in an individual? One formula for 'People with diabetes' and another for "People without diabetes'. Here, I have added a chart for these two groups of population. Usually, using this chart I can manually calculate cardiovascular risk. But I want an Excel formula that will automatically calculate the risk. In the chart, each number indicates the risk which can be estimated/calculated using the information: gender (men/women), smoker/nonsmoker, age, systolic blood pressure in mmHg, & total cholesterol level. For example, if a woman has diabetes, is a nonsmoker, is 63 years of age, and has a systolic blood pressure of 140 mmHg & total cholesterol of 6.5 mmol/l, her cardiovascular risk will be 9%. I will manually check the accuracy of the formula using the attached risk chart.