two formulas..are they the same

[w123kid]

Hi i have been working on a spreadsheet not originally designed by me

i have the following formula

=SUM((ThroughputFormulas!C11:C14)*(K2/30)/1024*ThroughputFormulas!C38*M2)
+(SUM(ThroughputFormulas!C33:C36)*Q2*(K2/30)/1024*ThroughputFormulas!C38*M2)



and this




=SUM(ThroughputFormulas!C11:C14)+[FONT=&quot](SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1024*M2[/FONT]



the difference between the two is that it will not multiply by ThroughputFormulas!C38 but i cannot get the second one to work (originally part of a longer formula)



Eliminating the ThroughputFormulas!C38 from the first formula will it give me same results in both... second one is probably an easier set up and would like to replace it but i cannot get it to work




help much appric?

 

[RoryA]

I think you want:
=(SUM(ThroughPutFormulas!C11:C14)+(SUM(ThroughPutFormulas!C33:C36)*Q2))*(K2/30)/1024*M2

 

[w123kid]

I think you want:
=(SUM(ThroughPutFormulas!C11:C14)+(SUM(ThroughPutFormulas!C33:C36)*Q2))*(K2/30)/1024*M2

Thanks
another quick one

i have the following formula

SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000)*M2)*3600)*O2))/(SUM(ThroughputFormulas!C39:C45))/1024/8)

the bold part of teh formula is only valid if a cell has determined onoly if a cell has a value of 60 (q2) how can i build the if stetament within it?

many thansk

 

[arthurbr]

Hi w123,
please put your formulae and code between tags ( advanced editing). It makes them ieasier to read , copy and edit.
Cheers

 

[RoryA]

What bold part?

 

[w123kid]

"SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000)*M2)*3600)*O2))/(SUM(ThroughputFormulas!C39:C45))/1024/8)"


Not sure how to do the advance stuff sorry

 

[RoryA]

If I understand you correctly, the bold part should become:

/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1)"

 

[w123kid]

=IF(ISERROR(((((((SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000)*M2)*3600)*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1)" ",((((((SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000)*M2)*3600)*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1)

Cannot get this to validate

Rorya you are being great help ta very much

 

[RoryA]

You will need to double-check this as I'm not 100% clear on what the original formula is actually meant to be:

=IF(ISERROR((SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000*M2*3600*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1))," ",(SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000*M2*3600*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1))

 

[w123kid]

You will need to double-check this as I'm not 100% clear on what the original formula is actually meant to be:

=IF(ISERROR((SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000*M2*3600*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1))," ",(SUM(ThroughputFormulas!C11:C14)*(100%-Q2)+(SUM(ThroughputFormulas!C33:C36)*Q2)*(K2/30))/1000*M2*3600*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1))

=IF(ISERROR((SUM(ThroughputFormulas!C11:C14)+(SUM(ThroughputFormulas!C33:C36)*Q2))*(K2/30)/1024*M2*3600*O2)/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1))," ",SUM((ThroughputFormulas!C11:C14)+(SUM(ThroughputFormulas!C33:C36)*Q2))*(K2/30)/1024*M2*3600*O2/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1))

check this one might have been a mistake in previous <o></o></pre>