Forum Discussion
Formula help
I have the following formula =XLOOKUP(LEFT($I5,3),LEFT('Rate Schedule'!$B5:$B16,3),'Rate Schedule'!C5:C16,"error") in cell K3 on my Jan Tab that is pulling a rate from the Rate Schedule Tab. The R...
Hi Carl, if you use the percentage formatting, this is what happens:
Multiplies the cell value by 100 and displays the result with a percent (%) symbol. You can specify the number of decimal places that you want to use.
See also here: Available number formats in Excel
To perform your comparison, you can also use the ROUND() function. So for example:
=IF(ROUND(K6,x)=ROUND(K3,x),True)For x, enter the number of relevant decimal places for your comparison.