You can use VALUE function to convert text to number.
VALUE function Converts a text string that represents a number to a number.
Syntax:
VALUE(text)
text is the text enclosed in quotation marks or a column reference containing the text you want to convert.
Use below formula(If your Column
A field always going to have valid number stored in it):
=IF(VALUE([Column A])>2000,IF([Column B]="Agreement","Yes","No"),"No")
Else, use below formula in case you want handle the error condition when Column A
field will not have valid number stored in it:
=IF(ISERROR(VALUE([Column A]))=TRUE,"No",IF(VALUE([Column A])>2000,IF([Column B]="Agreement","Yes","No"),"No"))
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).
In VALUE
function text parameter can be in any of the constant number, date, or time formats. If text is not in one of these formats, VALUE
returns the #VALUE!
or #Name?
error value(to avoid this error, make sure you are entring valid number in Column A).
References:
- VALUE function in SharePoint.