Excel Calculation Question I\'m trying to create a formula that will calculate 2

Question

Excel Calculation Question

I'm trying to create a formula that will calculate 2 cells added together resulting in a fraction that is not reduced, yet keeps the denominator the same as another cell

EXAMPLE: I would like to add fields B1 and B2 using the denominator in the "A" fields. so the result would end being the total in the "C" field.

Is there any way to do this?

B1 (BUNDLE+ ODDS)

12

Thanks !!

B1 (BUNDLE+ ODDS)

12

Explanation / Answer

Hi

try

If you don't want to be able to use the result as a number in other computations then

=TEXT(SUM(B1:B2),"# ??/"&A1)

But if you want to use the result as a number then you would be better simply using

=SUM(B1:B2) and giving it a custom number format of # ??/12

If there you need to use various different denominators you might be able to construct a macro to apply appropriate number formats to appropriate cells, but that would be dependent on the layout of the worksheet.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.