formula
 

How can I:

Hi,
I would like to know if it's possible to do this kind of formula:

= one cellule times another cellule if a specific cellule = 0

I explain my problem;

I have a product that use wood top or glass top and I am trying to do an
automatic calcul.

for wood top I need special connectors
and for glass top I need diferent connectors
(we use 2 connectors per showcase)

That will be something like connector for wood top = Number of showcase time
2 if glass top = 0

I hope I was clear enough

Thank you for your help

This is Urgent Thanks,

Eric.

formula
 

Try something like: =IF(A1=0,B1*C1,"")

Dave
--
Brevity is the soul of wit.


"Ricvideo" wrote:

How can I:

Hi,
I would like to know if it's possible to do this kind of formula:

= one cellule times another cellule if a specific cellule = 0

I explain my problem;

I have a product that use wood top or glass top and I am trying to do an
automatic calcul.

for wood top I need special connectors
and for glass top I need diferent connectors
(we use 2 connectors per showcase)

That will be something like connector for wood top = Number of showcase time
2 if glass top = 0

I hope I was clear enough

Thank you for your help

This is Urgent Thanks,

Eric.