Need help with #value!

Ask a question Seryn - Last answered on Nov 15, 2017 at 06:37 AM by Mazzaropi


I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #value!)

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?

Thank you for your help!! :)

plus moins
Seryn, Good morning.

Try to use:

=IF(C33="N/A", "", C33*B33)

Please, tell us if it worked for you.

I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!