How do I create a formula based on another field's results

D

Dave Bailey

I am trying to use the results of a drop down list to determine what formula
is used in another field.

The field with the drop down list has three values - CPM, CPC, and CPA
There are two input fields - Unit Cost and Units Ordered

If CPM then the equasion is Unit Cost * Units Ordered / 1000
If CPC then the equasion is Unit Cost * Units Ordered
If CPA then the equasion is Unit Cost * Units Ordered

The equasion would be in a field called Total Cost.

What is the easiest way to do this?

Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula not recognizing reference to "" in IF statement 2
Macro VBA coding, Copying content from one workbook to a new one 0
Help with an expression to calculate a profit from one of three fi 2
Programmatically fill drop-down list based on another field's valu 1
Change drop down list in one cell based on values in other cells 2
Formatting Rule: Diplay Section based on Selection in another section 0
Using a dynamic formula to calculate results based on different assumptions 0
Help with a Form based off of a Table 1

Top