I tried that and I'm still getting the VALUE error.

Jenny

"Niek Otten" wrote:

Probably because one of the cells is text, although it may look like a
number. Format all cells involved as number and re-enter the value (F2,
ENTER)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"msdobe" wrote in message
...
I used Paul's formula " =SUM(G2+H2)/D2 " and it was working perfectly.
Then
all of a sudden I keep getting a #VALUE! error in the cell. No matter
what
I try it keeps coming up. I deleted the *100 and just format the cell as
a
percentage, but I don't know why I keep getting the VALUE error.

http://www.microsoft.com/office/comm...lic.excel.misc