Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Money format in cell not working
I am using this formula to output a fee based on gross loss for insurance claim. The resulting total column shows proper dollar format when it is over $100,000 based on first IF statement. When it is either of the following IF statements, ie for losses > 500, or losses > than 0, then the "TOTAL" cell shows a dollar sign but is missing the coma at the thousand point, and the 2 zeros after the decimal point is not there either.
=IF([GROSS LOSS]2 > 100000, 0.024 * [GROSS LOSS]2, IF([GROSS LOSS]2 > 500, "290", IF([GROSS LOSS]2 > 0, "148")))
Thank you in advance for any ideas to help correct this!