Multiple IF & Sum formula

[jlyn123]

Hello,

I am trying to get the below formula to calculate an amount but I am getting a #VALUE error.

I need both of the highlighted portion of the formula to work and then sum anything in the rest of the columns.

Any help would be greatly appreciated.

 

[Cubist]

As far as I can tell, this part is missing the num_digits parameter.

 

[jlyn123]

View attachment 112959
As far as I can tell, this part is missing the num_digits parameter.

Thanks.

Now I am having issues with the below. Its returning FALSE which I know I need to enter an option for if the statement isnt true but I cant seem to get it to work in the formula. If false just want to return 0.

=IF(AND(X8>0.01,Q8>0.01),((Q8*X8*S8/100)+(SUM(Y8:Z8)*S8*Q8/100)),IF(AND(J8="No",Q8>0.01),((Q8/100*U8*S8)+(W8*R8/100)),IF(AND(V8>0.01,Q8>0.01),((Q8/100*((V8+SUM(Y8:Z8))*S8+(W8*R8/100)))))))

 

[Cubist]

Maybe this.

=IF(AND(X8>0.01,Q8>0.01),(Q8*X8*S8/100)+(SUM(Y8:Z8)*S8*Q8/100),
    IF(AND(J8="No",Q8>0.01),(Q8/100*U8*S8)+(W8*R8/100),
       IF(AND(V8>0.01,Q8>0.01),((Q8/100*((V8+SUM(Y8:Z8))*S8+(W8*R8/100)))),
         0)))

 

[jlyn123]

Thanks - this seems to work!!