Need help with #value!

Seryn - Nov 14, 2017 at 04:16 PM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Nov 15, 2017 at 06:37 AM
Hello,

Hello,

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!! :)

See more 

Your reply

1 reply

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Nov 15, 2017 at 06:37 AM
0
Thank you
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
Respond to Mazzaropi