This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
Gardener76
Bronze 5
Bronze 5
Since ‎02-10-2020
‎01-21-2024

My Stats

  • 50 Posts
  • 1 Solutions
  • 12 Likes given
  • 22 Likes received

Gardener76's Bio

Badges Gardener76 Earned

View all badges

Recent Activity

Number of opened and closed parentheses do not match.... where am I going wrong?

02-10-2023
Number of opened and closed parentheses do not match.... where am I going wrong?IFS(AND([Age]<49,[PSA]<2.5),"Your PSA Levels are within the referenced range proposed by NICE which is 2.5 for those between the age of 40 and 49.",AND([Age]>50,[Age] <59...

IFS and CONTAINS

02-10-2023
Hi I am trying to to put a price in a column, based on another column [Panel] containing certain codes. But not working. Advice where I am going wrong on this would be appreciated. Thanks in advance. IFS([Panel] CONTAINS("CMM40"),"25.50", CONTAINS("C...

Where am I going wrong?

02-10-2023
Hi I got this error: Expression 'IFS( AND([HBA1C] < 42,"20 - 42 mmol/L Your HBA1C levels are within normal limits.", AND([HBA1C] >= 43, [HBA1C] <=47, "43 - 47 mmol/L - Your results indicate that there is impaired glucose regulation and an increased r...

Expressions IF, AND OR?

10-26-2022
Hi I need some advice. I have tried AND, OR but nothing is seeming to work or maybe I am not understanding the language. I have 3 columns [Systolic],[Diastolic] and [BP Outcome]In [BP Outcome] I am trying to set the following parameters: If [Systolic...

change a column value based on a range from another column

10-19-2022
Whats the best way to change a column value based on a range from another column?I have BMI Column (number) and the Range column (text).The Range column (Underweight, Healthy, Overweight, Obese) will populate based on the ranges of the BMI column thi...
View more