Percent formula Answer Changes to error messa

September 30, 2010 at 07:05:09
Specs: Windows XP
I was using this formula in a spreadsheet:


and was getting an answer of 276.37%, but when I went into the cell clicked on the formula and then entered out of the cell the cell value changed to #Value!. The values of the cells are

B8: 19 B12: 482 I12: 35
C8: 10 C12: 41 J12: 2.5
D8: 8 D12: 382 K12: 1.5
E8: 22 E12: 0 L12: 5.25
F8: 35 F12: 562 M12: 0
G8: 25 G12: 0
H8: 19 H12: 0

I have been staring at this formula for a day and I cannot seem to duplicate the 276%. The formula is not mine, but apparently the 276% is the correct value. Could someone help me change the formula in order to get this result?

Thank you

See More: Percent formula Answer Changes to error messa

Report •

September 30, 2010 at 07:22:11
It was probably an array formula.

Put you cursor back in the cell and press Ctrl-Shift-Enter.

This will put curly brackets { } around the formula and tell Excel that it is an Array formula.

You can't just type in the { }. You have to use Ctrl-Shift-Enter every time you edit the formula.

Report •

September 30, 2010 at 07:24:18
Wow can't believe I didn't think of that. Guess it just takes a fresh pair of eyes. Thank you.

Report •

Related Solutions

Ask Question