RE: $$Excel-Macros$$ Help required in a small formula.....

2013-10-13 Thread Ravinder
E2=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2) E4=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: Saturday, October 12, 2013 2:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ Help required in a small formula.....

2013-10-11 Thread De Premor
This formula have 6 part *=1-(**(B3/D2)^2**+**(B4/D2)^2**+**(B5/D2)^2**+**(B5/D2)^2**+**(B6/D2)^2**+**(B7/D2)^2**)* And this Only 5 Part, Purple part was missing *=1-(**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**)* On 12-10-2013 3:52, Indrajit $nai wrote: Hello Experts, Kindly fi