hello permission to ask

Options

hello permission to ask

why the formula for the number is spelled out like this it can't be on the smartsheet


=IF(A1=0;"zero";IF(A1<0;"minus ";"")& SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE)) (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( IF(--MID(TEXT(000S(3)0001)");"); 0;"";MID(TEXT(ABS(A1);"000000000000000");1;1)&" hundred "&MID(TEXT(ABS(A1);"000000000000000");2;1)&"twenty "&MID (TEXT(ABS(A1);"000000000000000");3;1)&"trillion ")& IF(--MID(TEXT(ABS(A1);"000000000000000");4;3)=0;"" ;MID(TEXT(ABS(A1);"000000000000000");4;1)&" hundred "&MID(TEXT(ABS(A1);"000000000000000");5;1)&"twenty"&MID(TEXT(ABS (A1);"000000000000000");6;1)&" billion ")& IF(--MID(TEXT(ABS(A1);"000000000000000");7;3)=0;"";MID(TEXT (ABS(A1);"000000000000000");7;1)&" hundred "&MID(TEXT(ABS(A1);"000000000000000");8;1)&"twenty"&MID(TEXT(ABS(A1); "000000000000000");9;1)&" million ")& IF(--MID(TEXT(ABS(A1);"000000000000000");10;3)=0;"";IF(--MID(T EXT(ABS(A1);"000000000000000");10;3)=1;"*";MID(TEXT(ABS(A1);"000000000000000");10;1)&" hundred "&MID(TEXT(ABS (A1);"000000000000000");11;1)&"twenty ")&MID(TEXT(ABS(A1);"000000000000000");12;1)&" thousand ")& IF(--MID(TEXT( ABS(A1);"000000000000000");13;3)=0;"";MID(TEXT(ABS(A1);"000000000000000");13;1)&" hundred "&MID(TEXT(ABS(A1) ;"000000000000000");14;1)&"twenty"&MID(TEXT(ABS(A1);"000000000000000");15;1));1;"one");2;"two");3; "three");4;"four");5;"five");6;"six");7;"seven");8;"eight");9;"nine");"0 hundred ";"");"0ty";"");"onety 0";"ten");"onety one";"eleven");"onety two";"twelve");"one thirty-three";"thirteen");"onety-four";"fourteen");"onety-five";"fifteen");"onety-six";"sixteen");"onety-seven";"seventeen ");"one hundred";"eighteen");"onety-nine";"nineteen");"one hundred";"one hundred");"*one thousand";"one thousand");0;"" ));" ";" "))


or the formula is wrong, if there is a formula for the calculated amount, please help me, thank you

Answers