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

4 Replies

Detlef_Lewin
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

Resources