Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Feb 28, 2023

COMPLEX & ROUND

Dear Experts,                      Attached is the calculator , where I need a simpler formula.. rather than:-   =COMPLEX(ROUND(IF(ABS(IMREAL(D24))<$L$22,0,IF(ABS(1-IMREAL(D24))<$L$22,1, IF(ABS(1...
Formulas and Functions
dscheikey's avatar
dscheikey
Bronze Contributor
Mar 04, 2023

anupambit1797 

Just a small optimisation: You can use IFS() instead of the nested IF() statements.

=
COMPLEX(
   ROUND(
      IFS(
         ABS(IMREAL(D24))<$L$22,
         0,
         ABS(1-IMREAL(D24))<$L$22,
         1,
         ABS(1+IMREAL(D24))<$L$22,
         -1,
         TRUE,
         IMREAL(D24)
         ),
      $AB$1),
   ROUND(
      IFS(
         ABS(IMAGINARY(D24))<$L$22,
         0,
         ABS(1-IMAGINARY(D24))<$L$22,
         1,
         ABS(1+IMAGINARY(D24))<$L$22,
         -1,
         TRUE,
         IMAGINARY(D24)
         ),
      $AB$1),
   "j")

 

Resources