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.