COMPLEX & ROUND

Iron Contributor

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+IMREAL(D24))<$L$22,-1,IMREAL(D24)))),$AB$1), ROUND( IF(ABS(IMAGINARY(D24))<$L$22,0,IF(ABS(1-IMAGINARY(D24))<$L$22,1, IF(ABS(1+IMAGINARY(D24))<$L$22,-1,IMAGINARY(D24)))),$AB$1), "j" )

 

Thanks in Advance,

Br,

Anupam

1 Reply

@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")