ExcelBanter - Excel Formulas

ExcelBanter (https://www.excelbanter.com/)

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

- - Excel Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/206115-excel-formulas.html)

RickComputer

Excel Formulas

Could someone show me an example of a formula that adds and mutiplys in the
same cell?

Tom Hutchins

Excel Formulas

If A1 = 4, A2 = 5, and A3 = 6:
=A1*(A2+A3)
adds A2 + A3, then multiplies the result times A1. 4*(5+6) = 44

Hope this helps,

Hutch

"RickComputer" wrote:

Could someone show me an example of a formula that adds and mutiplys in the
same cell?

RickComputer

Excel Formulas

Thank You
That answers my question.

"Tom Hutchins" wrote:

If A1 = 4, A2 = 5, and A3 = 6:
=A1*(A2+A3)
adds A2 + A3, then multiplies the result times A1. 4*(5+6) = 44

Hope this helps,

Hutch

"RickComputer" wrote:

Could someone show me an example of a formula that adds and mutiplys in the
same cell?

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