I’m guessing there’s a typo in this:
Based on your topmost comment, I think you want $0, not $1800.
With that in mind, here’s my formula for {Field 3}:
IF({Field 2}, {Field 1} / {Field 2}, IF({Field 1}, {Field 1}, 0))
Thank you so much! That was a typo, my apologies, this is exactly perfect! That is so simple and exactly what I needed. I am really frustrated with myself that I couldn’t seem to make it work on my own. I’ve been struggling to get this to work all afternoon, you are officially my hero!
For anyone new coming to this thread, this formula didn’t work for me (got an “Invalid Formula” error message), but I have successfully used:
IF({Field 1} = 0, BLANK(), IF({Field 2} = 0, {Field 1}, {Field 1} / {Field 2}))
Replace BLANK() with 0 if you want to pull through 0 - that’s down to need and personal preference.
That all being said, did I miss something completely in the previous formula? Was I supposed to input my own logical statements in there somewhere? :woman_shrugging: Oh well, got there in the end!
For anyone new coming to this thread, this formula didn’t work for me (got an “Invalid Formula” error message), but I have successfully used:
IF({Field 1} = 0, BLANK(), IF({Field 2} = 0, {Field 1}, {Field 1} / {Field 2}))
Replace BLANK() with 0 if you want to pull through 0 - that’s down to need and personal preference.
That all being said, did I miss something completely in the previous formula? Was I supposed to input my own logical statements in there somewhere? :woman_shrugging: Oh well, got there in the end!
Welcome to the community, @Katherine_Traver1! :grinning_face_with_big_eyes:
Hard to say without having seen what you did when trying to use the formula. Sometimes copying and pasting goes awry. Maybe you missed a parenthesis or copied an extra character by mistake.
