Code: Select all
=IF(F19=-114;"1.8772";IF(F19=104;"2.04";IF(F19=-142;"1.7042";IF(F19=132;"2.32";IF(F19=-126;"1.7937";IF(F19=116;"2.16";IF(F19=135;"2.35";IF(F19=-145;"1.6897";IF(F19=170;"2.7";IF(F19=-180;"1.5556";IF(F19=107;"2.07";IF(F19=-131;"1.7634";IF(F19=184;"2.84";IF(F19=-198;"1.5051";IF(F19=-112;"1.8929";IF(F19=102;"2.02";IF(F19=-123;"1.8130";IF(F19=113;"2.13";IF(F19=-117;"1.8547";IF(F19=306;"4.06";IF(F19=-351;"1.2849";IF(F19=141;"2.41";IF(F19=-151;"1.6623";IF(F19=105;"2.05";IF(F19=-115;"1.8696";IF(F19=-107;"1.9346";IF(F19=125;"2.25";IF(F19=-105;"1.9524";IF(F19=-109;"1.9174";IF(F19=127;"2.270";IF(F19=-102;"1.9804";IF(F19=164;"2.640";IF(F19=110;"2.1";IF(F19=100;"2.0";IF(F19=229;"3.29";IF(F19=161;"2.61";IF(F19=179;"2.79";IF(F19=151;"2.51";IF(F19=-121;"1.8624";IF(F19=-128;"1.7813";IF(F19=130;"2.3")))))))))))))))))))))))))))))))))))))))))
My issue is I am no longer able to add any more "IF" statements to the formula without getting "Err:514", some sort of overflow error.
Any suggestions on how I could continue to add "IF" statements without returning this error? Or perhaps there's a simpler formula for converting the numbers? I am no expert with these formulas by any means