You can use VALUE function to convert text to number.
VALUE function Converts a text string that represents a number to a number.
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"))
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(,).
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
#Name? error value(to avoid this error, make sure you are entring valid number in Column A).
- VALUE function in SharePoint.