Skip to main content

I would like to utilize a formula to calculate pricing that is contained within Single Select text.


One of my fields includes a Single Select drop down like this:

Heading: {Initial Program Cost}

325 for Massage (first 3 hours)


The next field includes a Single Select drop down like this:

Heading: {Additional Hourly Cost}

125 for Massage (each additional hour)


The next field includes a number:

Heading: {Additional Hours}

3


**I am looking for a formula that would calculate the total cost:

{Initial Program Cost} + {Additional Hourly Cost}*{Additional Hours}

325+375

I would appreciate any help!!!

LEFT({Initial Program Cost},'FIND(' ',{Initial Program Cost})-1')+LEFT({Additional Hourly Cost},'FIND(' ',{Additional Hourly Cost})-1')*{Additional Hours}

LEFT({Initial Program Cost},'FIND(' ',{Initial Program Cost})-1')+LEFT({Additional Hourly Cost},'FIND(' ',{Additional Hourly Cost})-1')*{Additional Hours}


Thank you! I tried this, based off of what you wrote, and it worked! Amazing!


(VALUE(LEFT({Initial Program Cost},FIND(" “,{Initial Program Cost})-1)))+((VALUE(LEFT({Additional Hourly Cost},FIND(” ",{Additional Hourly Cost})-1)))*{Additional Hours})

Reply


Terms & Conditions