Thanks Vaibhav
On Sat, Dec 6, 2014 at 7:26 PM, Vaibhav Joshi wrote:
> Probably..
>
>
> =IF(U5<50,0,IF(W5="T1",(C5*sheet1!$B$9)+(D5*sheet1!$B$2)+(E5*sheet1!$B$3)+(F5*sheet1!$B$8)+(G5*sheet1!$B$8)+(H5*sheet1!$B$7)+(I5*sheet1!$B$7)+(K5*sheet1!$B$6)+(L5*sheet1!$B$6)+(M5*sheet1!$B$4)+(N5*sheet1!$B$5
Probably..
=IF(U5<50,0,IF(W5="T1",(C5*sheet1!$B$9)+(D5*sheet1!$B$2)+(E5*sheet1!$B$3)+(F5*sheet1!$B$8)+(G5*sheet1!$B$8)+(H5*sheet1!$B$7)+(I5*sheet1!$B$7)+(K5*sheet1!$B$6)+(L5*sheet1!$B$6)+(M5*sheet1!$B$4)+(N5*sheet1!$B$5)+(J5*sheet1!$B$10)+(O5*sheet1!$B$11)+(P5*sheet1!$B$12)+(Q5*sheet1!$B$13)+(R5*s
Hi
You haves nor closed last loop of if statement,
IF(W5="T4",(C5*sheet1!$E$9)+(D5*sheet1!$E$2)+(E5*sheet1!$E$3)+(F5*sheet1!$E$8)+(G5*sheet1!$E$8)+(H5*sheet1!$E$7)+(I5*sheet1!$E$7)+(K5*sheet1!$E$6)+(L5*sheet1!$E$6)+(M5*sheet1!$E$4)+(N5*sheet1!$E$5)+(J5*sheet1!$E$10)+(O5*sheet1!$E$11)+(P5*sheet1!$
