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]

That doesn't bear much relation to the last formula you posted so I don't really have a clue what it is you want. Can you either post a sample or explain in words what you are trying to calculate and what values are in the referenced cells? It might be easiest to ignore the ISERROR part and simply post a working version of the main formula if you have one.

 

[w123kid]

think i got it
i had a percentage column that i converted to numeric that through off all my calc

now the IF statement i am having problems with when comparing to a percentage

in q2 i have a drop down list 0f 0% 10% to 100% but the statemnt

IF(Q2<70%
doesnt seem to be applying, can you advice

great help as always

 

[RoryA]

Try entering =Q2<70% in a cell and see if it returns TRUE or FALSE.

 

[w123kid]

Try entering =Q2<70% in a cell and see if it returns TRUE or FALSE.

yeah get true and false depending on value

 

[RoryA]

If it works like that then it should work in the formula. What is the current version of the formula?