Unit conversion is not properly functioning.

[ajmal pottekattil yoousuf]

I selected the "MΩ" but excel selected the "mΩ" so the required output is not getting properly.

[#2]

@ajmal pottekattil yoousuf 

Use EXACT() instead of the comparative operator.

[#3]

could you please guide me how to use this formula.

[#4]

@ajmal pottekattil yoousuf 

How to use the exact function in excel 

[#5 · Accepted solution]

@ajmal pottekattil yoousuf 

Workbook attached.