ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formulas (https://www.excelbanter.com/excel-discussion-misc-queries/80899-formulas.html)

Creighton

formulas
 
what formula do i use to get this

A1 x B1 + C1 = D1

or

quantity x price ea + shipping = total

Alan

formulas
 
In D1

=A1*B1+C1

Regards,
Alan
"Creighton" wrote in message
...
what formula do i use to get this

A1 x B1 + C1 = D1

or

quantity x price ea + shipping = total




choc_penguin

formulas
 

Type in D1

=A1 * B1 + C1

???


--
choc_penguin
------------------------------------------------------------------------
choc_penguin's Profile: http://www.excelforum.com/member.php...o&userid=30099
View this thread: http://www.excelforum.com/showthread...hreadid=528747


keithl816

formulas
 

In D1 place

=sum(a1*b1+c1)


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=528747


David Biddulph

formulas
 
"keithl816" wrote
in message ...

In D1 place

=sum(a1*b1+c1)


Why the "sum", Keith?
--
David Biddulph



Peo Sjoblom

formulas
 
If that's not a rhetorical question then SUM is obsolete in this case, no
need at all but fairly common
nevertheless.
If it is then you already know that <g


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"David Biddulph" wrote in message
...
"keithl816" wrote
in message ...

In D1 place

=sum(a1*b1+c1)


Why the "sum", Keith?
--
David Biddulph





All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com