# two formulas..are they the same

#### w123kid

##### New Member
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 ?

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### RoryA

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

#### w123kid

##### New Member
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 Hi w123,
Cheers

#### RoryA

##### MrExcel MVP, Moderator

What bold part? #### w123kid

##### New Member
"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

##### MrExcel MVP, Moderator

If I understand you correctly, the bold part should become:
Code:
``/IF(Q2=60,SUM(ThroughputFormulas!C39:C45)/1024/8,1)"``

#### w123kid

##### New Member
Code:
``=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

##### MrExcel MVP, Moderator
You will need to double-check this as I'm not 100% clear on what the original formula is actually meant to be:
Code:
``=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

##### New Member
You will need to double-check this as I'm not 100% clear on what the original formula is actually meant to be:
Code:
``=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))``

Code:
``=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>

Last edited: Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,164,290
Messages
5,836,437
Members
430,429
Latest member
monkeyhalf ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back