ExcelBanter - Simple arithmetic

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

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

- - Simple arithmetic - take 2 (https://www.excelbanter.com/excel-discussion-misc-queries/6742-simple-arithmetic-take-2-a.html)

Simple arithmetic - take 2

Here is another arithmetic question.

The formula is in BF224

=(AZ224+AV224+AU224+AI224)*AR224+BF224

AZ224 = (blank)
AV224 = (blank)
AU224 = 0.08
AI224 = 8.41
AR224 = 35%
BF224 = (The result added to the formula)

The correct answer should be 11.46

AZ224 and AV224 are blank and are the result of a formula.

Pat

ok i see one problem. iff the formula is in BF224 u cant add it as part of
the equation. other than taht it looks good

u can do this too:

=SUM(AZ224,AV224,AU224,AI224)*AR224

but that +BF224 wont work if ur inouting the equation in that cell.

"Pat" wrote:

Here is another arithmetic question.

The formula is in BF224

=(AZ224+AV224+AU224+AI224)*AR224+BF224

AZ224 = (blank)
AV224 = (blank)
AU224 = 0.08
AI224 = 8.41
AR224 = 35%
BF224 = (The result added to the formula)

The correct answer should be 11.46

AZ224 and AV224 are blank and are the result of a formula.

Pat