View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
BenjieLop
 
Posts: n/a
Default Multiplying a # in a cell to total an $ in another cell


VTOCorp Wrote:
Hello,

This might be a HUGE Newbie question but I am trying to figure out a
Order Form.

This is what I am trying to work with :
Qty| Price/Ea. =Amount


_-3___X-_ _15.95_ = _$47.85_



If this doesn't make sense, just let me know... Technically it should
be a easy task, but I just can't seem to get it working...

Thanks


ASSUMING that

A1 = Qty
B1 = Unit Price
C1 = Amount

your formula will be (enter in Cell C1)

=A1*B1

Hope this is what you are looking for.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=491481