This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Formula to multiply Sale Price column which is formatted as Single Line Text by ONP Net% column which is formatted as percent (1.00) to fill the ONP Commission column which contains the formula and format as currency.
Throws and ERROR no matter what ...
Excluding the * was my error in typing out the formula into the message. The * was in the formula in my table.
Removing the Value function for just the ONP Net% part did work though.
Thank you
