it varies. It could be =a3-a1 or =sum(l23:l34) or =l35/l57*1000 The most
complex was a =ROUND

"Frank Kabel" wrote:

Hi
what formula is in these cells?

"Brenda" wrote:

have a huge complex workbook. Several of the cells contain the error #num!.
If I click on a cell with the error message, press F2 key then enter, the
error message goes away. any suggestions why?