Multiplying a # in a cell to total an $ in another cell
 

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_

:confused:

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


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

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_

:confused:

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

Multiplying a # in a cell to total an $ in another cell
 

BenjieLop Wrote:
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.

Thanks alot, I knew it would be an easy formula! Exaclty what I wanted!


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

Multiplying a # in a cell to total an $ in another cell
 

VTOCorp Wrote:
Thanks alot, I knew it would be an easy formula! Exaclty what I wanted!

You are welcome ... glad I can be of help.

Regards.


--
BenjieLop


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