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

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,730
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,224
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
36,730
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
36,730
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
36,730
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:

Watch MrExcel Video

Forum statistics

Threads
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.
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