Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |