Forum Discussion

loganwol's avatar
loganwol
Microsoft Employee
10 years ago
Solved

How to check for Infinity value

Hi,

 

I have a table with two columns that represent Upper and Lower Limits for measurement values of a system. The limit values can be valid integer values, Blank or (+/-)Infinity. I want to check for the following -

a. If both the values are not Infinity or blank.

b. If one of the values is not Infinity or blank.

c. If both the values are Infinity or blank.

 

I am using the ISBLANK function to cover the check for blank but can't find a function for Infinity something similar to ISNAN. Anybody know of a way to check for Infinity values.

 

Regards,

Sunil

  • Anonymous's avatar
    Anonymous
    10 years ago

    I think infinite values will read as errors, so ISERROR(TableName[ColumnName]) should do it. Otherwise you could try NOT(ISNUMBER(TableName[ColumnName]))

7 Replies