Forum Discussion

djclements's avatar
djclements
Silver Contributor
Nov 26, 2023

Re: IF Statements with formulas

bellmatthias Try using the ROUND function to round the results of your calculation to the appropriate number of decimal places. If you're dealing with whole numbers, for example, try any variation of the following:

 

=ROUND(K14, 0)=L14

 

- OR -

 

=ROUND(K14, 0)=ROUND(L14, 0)

 

- OR -

 

=ROUND(K14-L14, 0)=0
No RepliesBe the first to reply

Resources