two formulas..are they the same

w123kid

New Member
Joined
May 9, 2008
Messages
42
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:cool:?
 

Excel Facts

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

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,804
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I think you want:
=(SUM(ThroughPutFormulas!C11:C14)+(SUM(ThroughPutFormulas!C33:C36)*Q2))*(K2/30)/1024*M2
 

w123kid

New Member
Joined
May 9, 2008
Messages
42
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

Well-known Member
Joined
Dec 8, 2006
Messages
2,395
Office Version
  1. 2010
Hi w123,
please put your formulae and code between tags ( advanced editing). It makes them ieasier to read , copy and edit.
Cheers
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,804
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

What bold part? :)
 

w123kid

New Member
Joined
May 9, 2008
Messages
42
"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
Joined
May 2, 2008
Messages
38,804
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

w123kid

New Member
Joined
May 9, 2008
Messages
42
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
Joined
May 2, 2008
Messages
38,804
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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
Joined
May 9, 2008
Messages
42
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:p></o:p></pre>
 
Last edited:
Master Excel Bundle

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

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top