Thread: formula for multiply one cell to one of two other cells?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default 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/
Reply With QuoteReply With Quote