calculation Problem

@clipperMar 21.2005

I have the following calculation:

if (Cell[A,9] >0)
{
if(Cell[H,9] – (((Cell[B,9] * Cell[I,9]) + (Cell[C,9] * Cell[J,9])) / Cell[A,9])<= 0.02)
{
return true;
}
else
{
return false;
}
}

Cell[A,9] == 4000
Cell[H,9] == 1.02
Cell[B,9] == 3000
Cell[I,9] == 1
Cell[C,9] == 1000
Cell[J,9] == 1

Using the data above I think this calculation should return 0.02 as my answer. Have I my calculation built correctly?

to post a comment

JavaScript

@scragarMar 21.2005 — #

[code=php]if (Cell[A,9] >0){
 if(Cell[H,9] - (((Cell[B,9] * Cell[I,9]) + (Cell[C,9] * Cell[J,9])) / Cell[A,9]) <= 0.02){
 return true;
 }else{
 return false;
 }
 }
 
 //inserting numbers:
 if (4000 >0){//true
 
 //  if(1.02 - (((3000 * 1) + (1000 * 1)) / 4000) <= 0.02){
 //  if(1.02 - ((3000 + 1000) / 4000) <= 0.02){
 //  if(1.02 - (4000 / 4000) <= 0.02){
 //  if(1.02 - 1 <= 0.02){
 if(0.02 <= 0.02){//should return true.
 return true;
 }else{
 return false;
 }
 }
 [/code]

the problem is your use of numbers, try alerting out the numbers through several stages, your final number for the left hand side in the second if comes out as "0.020000000000000018" because the number does not work out very well in binary(you can only get very close, not precise)

something like this will work better:

[code=php]if (Cell[A,9] >0){
 if(Math.floor(100 * (Cell[H,9] - (((Cell[B,9] * Cell[I,9]) + (Cell[C,9] * Cell[J,9])) / Cell[A,9]))) <= 2){
 return true;
 }else{
 return false;
 }
 }[/code]

@clipperauthorMar 21.2005 — #cheers for that works perfect

@clipperauthorMar 21.2005 — #When I use the following data the calulation given does not work:

Cell[A,9] == 5

Cell[H,9] == 0.43

Cell[B,9] == 2000

Cell[I,9] == 1

Cell[C,9] == 3000

Cell[J,9] == 0

Is there any way to do this calculation so that it consistently works for different data?

@scragarMar 21.2005 — #

[code=php]if (Cell[A,9] >0){ 
 if(Math.round(100 * (Cell[H,9] - (((Cell[B,9] * Cell[I,9]) + (Cell[C,9] * Cell[J,9])) / Cell[A,9]))) <= 2){ 
 return true; 
 }else{ 
 return false; 
 } 
 }[/code]

that should now work, but note that there are still some combos for which this won't work...

It would take a function about 200-300 times as big as your current if's to get it working for every value...

@clipperauthorMar 21.2005 — #Thank You

calculation Problem

5 Comments(s) _↴

Also in #JavaScript _↴

Success!

Social

Version

calculation Problem

5 Comments(s) ↴

Also in #JavaScript ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

5 Comments(s) _↴

Also in #JavaScript _↴