Need help with #value!

Closed
Seryn - Nov 14, 2017 at 04:16 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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!! :)

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 15, 2017 at 06:37 AM
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
0