Stephen wrote:
Paul, that's awesome, it worked. Now, though, if I get a number too
large for cells S12, V12, or Y12 I get pound signs in those where I
didn't before. What's up with that? Do you have any suggestions.
Not without seeing the sheet. Any chance you can post a copy of it on the
web somewhere?

If
not, thanks alot for what you've done so far.

"Paul Lautman" wrote:

Stephen wrote:
Reducing the size only makes the pound signs smaller, it doesn't
help fix the problem.
It does once you make is small enough!

I've just come up with an idea. Try:

=TEXT(IF(V12=0,S12,IF(Y12=0,S12*V12,IF(Y120,S12*V 12*Y12))),"#")

Let me know if it works