Thread: Divide and round
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default Divide and round
Hi again

You can do it with a single formula for range B1:M1 too:
B1=ROUND((2*$A$1-SUM($A$1:A$1))/(12-COLUMN()+2),3)
and copy to B1:M1


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


Reply With QuoteReply With Quote