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())
