Need help with #value!

[Closed]
Report
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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 reply

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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