Forum Discussion
UK_User123456
Resolver I
Resolver IIf statement to check if a value is between two values and return text
Hi All, Probably really simple but I am trying to return text if a number falls between two values as follows: Difference 3 100 500 320 410 210 If one of the above...
Result = IF(and(Table1[Difference]>0 , Table1[Difference]<365),"Active",BLANK())
Result = IF(and(Table1[Difference]>0 , Table1[Difference]<365),"Active",BLANK())
This works great! I am wondering if it is possible to show the text as a label on a bar chart. It appears when you select "show as a table" but not on the actual bar chart. Any thoughts?