Skip to main content

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 I try.


Have tried:

VALUE({Sale Price})VALUE({ONP Net%})

{Sale Price}{ONP Net%}

Changing format of Sale Price to currency (which breaks all the other formulas too)


Adding VALUE worked to fix the ERROR on all other columns except the the ONP Commission column.


Any suggestions?

Hi @Cindy_Hood,


Welcome to Airtable Community! :grinning_face_with_big_eyes:


You did not add the multiply symbol in your formulas (*) , also since {ONP Net%} is formatted as percentage already, dont use the Value function on it.


So it should be


VALUE({Sale Price}) * {ONP Net%}


BR,

Mo

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

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


Welcome. Please mark your question as answered 🙂

Reply


Terms & Conditions