Hello. I can assist you with your question.
do you need any more info from me or are you working on a formula?
What I would do... just did this earlier is keep it simple.
So I would create another column, which you will later hide.
And in that column test for the condition to decide the falue
So in the new column you can have =if(a1="DOG"),(a2*A3,0)
ok...just thinking about this
hmmm...I think that worked. I was expecting something far more complex
There are much more complex ways to do it.
Did you want to go that route?
They break very easily.
There isn't really a "moderately complex" way
But if it does do what you need it to... and it's easy to understand, that's what I would chose.
well I guess one day it might be nice to learn..but simple is good. You helped me get over the stumbling block...Thanks.