If Error Added to ROI Formula

Tony Barthelemy

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

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

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

Tony Barthelemy

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

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

Genevieve P.

Hi @Tony Barthelemy

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