If Error Added to ROI Formula

Smartsheet Community:
I tried to add IFError to the Formula below to Return Blank in the Event I have 0.00 Investment (Investment $$ Column)
Original Formula:
=([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row
Thanks
Best Answer
-
Disregard Smartsheet Community! I figured it Out and I missing a Parenthesis.
=IFERROR(([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row, "")
Answers
-
Disregard Smartsheet Community! I figured it Out and I missing a Parenthesis.
=IFERROR(([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row, "")
-
I'm glad you were able to figure it out! Thanks for posting your solution. π
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!