Need help with #value!

[Closed]
Report
-
Hello,

I need a formula that will change answer based on selection from drop down box

B33 can be any number from 0-10, it has a drop down box where I can choose 0,1, etc.
C33 also has a drop down where I can choose two options N/A or $175.00

If I choose 0 in B33 and N/A in C33, then answer in D33 should be blank or -
if I choose 1 in B33 and $175 in C33, then answer in D33 should be $175.00
or if I choose 2 in B33 and $175.00 in C33, then answer in D33 would multiply B33 by C33 and so on and so forth

How can I create a formula for this?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!