Greater than formula in IF formula

[Vaibhav0208]

I was trying If THEN ELSEIF THEN ELSE formula and in between that using And formula. In And i was trying to use greater than as [ABS]>[Right amount] but it is showing error.

[gautiergodard · Accepted solution]

@Vaibhav0208 Would you be able to share some sample data and the exact formula you are trying to use? 

For greater than, ensure that the variables you are comparing are numerical or date data types in order to get the desired results.

[Vaibhav0208]

[gautiergodard]

@Vaibhav0208 just to confirm, was the issue the data type? 

If not, please provide some sample data and copy the formula you are using into the comment so we can trouble shoot offline.