View Single Post
 
Old 03-06-2015, 01:49 PM
ciresuark ciresuark is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 7
ciresuark is on a distinguished road
Default Combo Box Content Control Calculate on selection help

Hello,

I am trying to have a number calculated by the result of a combo box. I am having trouble setting up the If formula based on the selection. I was able to start the IF formula with
Code:
{ IF { REF One } = "Two" "500" "" }
How do I add to the if formula to include selections of three and four?

Is there a way to make the If function calculate upon the selection of the Combo Box through VBA or another means?

Your help is much appreciated.
Reply With Quote