Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DOK DOK is offline
external usenet poster
 
Posts: 3
Default how? =C4*H4 or K4

How can I multiply from one cell or another cell to receive an answer in a
third cell?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 192
Default how? =C4*H4 or K4

What are your conditions for wanting to multiply in separate cells? If it's
because H4 is blank you can write:

=IF(H4="",C4*K4,C4*H4)
--
-SA


"dok" wrote:

How can I multiply from one cell or another cell to receive an answer in a
third cell?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,651
Default how? =C4*H4 or K4

On Thu, 17 Jul 2008 14:24:02 -0700, dok wrote:

How can I multiply from one cell or another cell to receive an answer in a
third cell?


Put your formula in the third cell.
--ron
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 189
Default how? =C4*H4 or K4

Hi,

Say for e.g that in col A you have a value and in col B you have another
value. Now if you want multiply the values of col A with col B and the result
you want in col C then the simplest formula is
=A1*B1
you will get the result in C or in any cell that you select.
--
Thanks
Suleman Peerzade


"dok" wrote:

How can I multiply from one cell or another cell to receive an answer in a
third cell?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"