Tough one this !

[Kriss Lee]

Hi guys, desperately seeking help

I am attempting to Multiply a cell in another cell by using PRODUCT, my problem is this . . .

A1 is a currency format cell which is then multiplied by A2 with a number format, I cannot for the life of me figure out how to have A3 show a zero in currency format when A2 is empty, Product just returns the value of A1

Please show this befuddled old git how to fix this

TIA

 

[Eric W]

Welcome to the MrExcel forum!

Here are 3 possibilities:

Book1
	A	B	C
1	$ 100.00
2
3	$ -	$ -	$ -
Sheet3

Cell Formulas
Range	Formula
A3	A3	=A1*A2
B3	B3	=PRODUCT(A1,A2+0)
C3	C3	=PRODUCT(A1,N(A2))

A3 doesn't use PRODUCT. B3 does if for some reason you really want to use it instead of just the * operator. And C3 will give you a result if the empty cell in A2 is the result of a formula.

 

[Kriss Lee]

Thank you Eric, many hours of headscratching never even got me close

Genius

Much appreciated

 

[Eric W]

Happy to help! Thanks for the update.

 

[Kriss Lee]

OOOps, Forgot to say the B3 formula did exactly what I wanted it o

Thank you again