If Error Added to ROI Formula

Tony Barthelemy · 02/21/21

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

Tony Barthelemy · 02/21/21

Disregard Smartsheet Community! I figured it Out and I missing a Parenthesis.

=IFERROR(([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row, "")

Tony Barthelemy · 02/21/21

Disregard Smartsheet Community! I figured it Out and I missing a Parenthesis.

=IFERROR(([Gain Or Loss]@row - [Investment $$]@row) / [Investment $$]@row, "")

Genevieve P. · 02/22/21

I'm glad you were able to figure it out! Thanks for posting your solution. 🙂

Best Answer