Forum Discussion

ajmal_pottekattil_yoousuf

Iron Contributor

Mar 20, 2023

Solved

Unit conversion is not properly functioning.

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

New Microsoft Excel Worksheet.xlsx10 KB

HansVogelaar
Mar 20, 2023
ajmal_pottekattil_yoousuf

Workbook attached.
New Microsoft Excel Worksheet.xlsx11 KB

Silver Contributor

Mar 20, 2023

ajmal_pottekattil_yoousuf

Use EXACT() instead of the comparative operator.

ajmal_pottekattil_yoousuf

Iron Contributor

Mar 20, 2023

could you please guide me how to use this formula.

HansVogelaar
MVP
Mar 20, 2023
ajmal_pottekattil_yoousuf

Workbook attached.
New Microsoft Excel Worksheet.xlsx11 KB
Detlef_Lewin
Silver Contributor
Mar 20, 2023
ajmal_pottekattil_yoousuf
How to use the exact function in excel

Resources