# 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 Joke
Why can't spreadsheets drive cars? They crash too often!

#### 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

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:

Replies
4
Views
55
Replies
1
Views
173
Replies
2
Views
172
Replies
3
Views
179
Replies
2
Views
97

1,130,112
Messages
5,640,167
Members
417,128
Latest member
Xianter

### 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