Forum Discussion
IF Statements with formulas
Hi, I am trying to use an IF formula as a part of conditional formatting. The IF formula is "IF(K14=L14,TRUE,FALSE)". Every time I try to use the IF formula it says the logic is false. The two ce...
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