How to check for Infinity value

[loganwol]

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

[khuswant89]

thanks for providing the solution. shareit for pc http://forpcguide.com

[smyanken]

Thanks for sharing download the share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too... http://shareit-app.com

[mallukutta]

Thanks for sharing download the share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too :.. Download the app from the below given link : https://www.shareitforwindows.com/

[KHorseman · Accepted solution]

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

[mallukutta]

Share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too :.. Download the app from the below given link : https://www.shareitforwindows.com/

[techphiz]

https://allmailinfo.com/www-hotmail-com-sign-up-sign-in-login/

[mallukutta]

Thanks for sharing download the share it app for that transfer from the given link it's one the best alternative to the other data transfer apps like airdroid and xender ans pushbullet too :.. Download the app from the below given link : https://www.shareitforwindows.com/