Help

Re: Inability to format a formula

Solved
Jump to Solution
598 1
cancel
Showing results for 
Search instead for 
Did you mean: 
April_Kastner
6 - Interface Innovator
6 - Interface Innovator

IF(Paid>0,({Profit}/{Paid}*100),"")

This is my current formula after playing with it for some time. I am calculating ROI, with many of my records containing no initial investment, which left the result of {profit/paid} as infinity on those lines. I want to easily calculate my average ROI, so I can’t have the infinity records. Initially, I thought I could add to the formula IF({profit/paid}=“infinity”,""), but that formula failed, so I ended up with the above. The problem is, because of that formatting, I now cannot format the formula to show results as a %. Any ideas?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Stick to your first formula and just remove the final comma and quotation marks.

So, make it look like this:

IF(Paid>0,({Profit}/{Paid}*100))

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

Stick to your first formula and just remove the final comma and quotation marks.

So, make it look like this:

IF(Paid>0,({Profit}/{Paid}*100))

Oh my gosh, the amount of time I spent on that and it was right in front of me :grinning_face_with_sweat: It worked perfectly! Thank you so much!

Ha, you’re welcome! Glad I could help! :slightly_smiling_face: