"c.welch" wrote:

What I'd like to do is create a set of conditional statements. If the cell
a1="cat", then the number in a2*.25. If the cell a1="dog", then the number
in a2*.75. A1 will always say dog or cat. The then part of the statement
changes based on the text. Any suggestions on how to accomplish this?
Thanks.

Thanks for your quick response Paul!