Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
Need help for creating a formula.
I need a formula to do the folowing on Excel 2003 program : B1 cell x ( C1 and or D1 ) and put the figure on E1 in other words : multiply B1 to either C1 and or D1 and put the calculated figure on E1. Thanks in advance. best wishes M.Rafat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
How do you decide if you want it multiplied by C1 or D1? What are the
conditions? "M.Rafat" wrote in message ... Need help for creating a formula. I need a formula to do the folowing on Excel 2003 program : B1 cell x ( C1 and or D1 ) and put the figure on E1 in other words : multiply B1 to either C1 and or D1 and put the calculated figure on E1. Thanks in advance. best wishes M.Rafat |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
there is no conditions , but I wish to use one of C1 or D1 cell to be
multiplied by B1. actually , one of C1 or D1 has 0 ( zero ) value and the other has number ( value ) . is it enough or I may send the snapshot of what I am looking for ? Thanks in advance. M.Rafat "Michael Behm" wrote: How do you decide if you want it multiplied by C1 or D1? What are the conditions? "M.Rafat" wrote in message ... Need help for creating a formula. I need a formula to do the folowing on Excel 2003 program : B1 cell x ( C1 and or D1 ) and put the figure on E1 in other words : multiply B1 to either C1 and or D1 and put the calculated figure on E1. Thanks in advance. best wishes M.Rafat |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
=B1*(C1+D1)
-- David Biddulph "M.Rafat" wrote in message ... there is no conditions , but I wish to use one of C1 or D1 cell to be multiplied by B1. actually , one of C1 or D1 has 0 ( zero ) value and the other has number ( value ) . is it enough or I may send the snapshot of what I am looking for ? Thanks in advance. M.Rafat "Michael Behm" wrote: How do you decide if you want it multiplied by C1 or D1? What are the conditions? "M.Rafat" wrote in message ... Need help for creating a formula. I need a formula to do the folowing on Excel 2003 program : B1 cell x ( C1 and or D1 ) and put the figure on E1 in other words : multiply B1 to either C1 and or D1 and put the calculated figure on E1. Thanks in advance. best wishes M.Rafat |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
On Apr 12, 3:00 pm, M.Rafat wrote:
there is no conditions , but I wish to use one of C1 or D1 cell to be multiplied by B1. actually , one of C1 or D1 has 0 ( zero ) value and the other has number ( value ) . is it enough or I may send the snapshot of what I am looking for ? Thanks in advance. M.Rafat "Michael Behm" wrote: How do you decide if you want it multiplied by C1 or D1? What are the conditions? "M.Rafat" wrote in message ... Need help for creating a formula. I need a formula to do the folowing on Excel 2003 program : B1 cell x ( C1 and or D1 ) and put the figure on E1 in other words : multiply B1 to either C1 and or D1 and put the calculated figure on E1. Thanks in advance. best wishes M.Rafat- Hide quoted text - - Show quoted text - Enter this formula into E1: =IF(C1=0,B1*D1,B1*C1) -Shaun Scovil |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
Thu, 12 Apr 2007 12:00:02 -0700 from M.Rafat
: there is no conditions , but I wish to use one of C1 or D1 cell to be multiplied by B1. actually , one of C1 or D1 has 0 ( zero ) value and the other has number ( value ) . If either C1 or D1 is zero, and you want to multiply by the nonzero one, then multiply by (C1+D1). -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for multiply one cell to one of two other cells?
Thank you very much .
I use this formula you and David Biddulph suggested and it works. Thank you again. regarding Shaun Scovil's formula , i will work on it and let you know the result. best wishes M.Rafat "Stan Brown" wrote: Thu, 12 Apr 2007 12:00:02 -0700 from M.Rafat : there is no conditions , but I wish to use one of C1 or D1 cell to be multiplied by B1. actually , one of C1 or D1 has 0 ( zero ) value and the other has number ( value ) . If either C1 or D1 is zero, and you want to multiply by the nonzero one, then multiply by (C1+D1). -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
Need help with a Multiply Dependent One Cell Formula | Excel Worksheet Functions | |||
How do I Multiply different cells by one number as a formula? | New Users to Excel | |||
Would like one cell to both count and multiply a range of cells | Excel Worksheet Functions | |||
How do I multiply a cell by the product of two other cells? | Excel Discussion (Misc queries) |