Not with a formula. Formula only return values. You can use a macro
if range("a5")=25 then
ActiveCell.EntireRow.Copy
ActiveCell.Offset(1).entirerow.Insert
Application.CutCopyMode = False
--
Don Guillett
SalesAid Software
"Mindie" wrote in message
...
Is it possible based on a formula to insert an additional row. For
example,
If cell A5=25, I want to insert a row and duplicate the existing row..