Thread: formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default formulas

No problem. Happens to me often <g

--
Regards

Roger Govier


wrote in message
ps.com...
Roger Govier wrote:
There was a small typo in the formula posted by Joue
=INT(($A$1-SUM($B$1:B1)/(ROW($B$7)-ROW()+1))

is missing a closing bracket before the "/" sign


Thanks for picking up on that. I don't know how that happened, since
I
am sure that I cut-and-pasted from a spreadsheet. I suspect I made a
last-minute edit, and I misplaced the cursor before pressing Backspace
:-(.