wierd result: CurAfterWitholdingTax = CurGross * 0.23

[Big1934]

CurAfterWitholdingTax = CurGross * CurPercentWithHoldingTax

so basic but is my logic wrong, i get for CurAfterWitholdingTax the value of -42500 or a negative number similar to that. the value of CurPercentWithHoldingTax is 0.23 which is grabbed from a forms text box.

I am not suprised if the answer is obvious to you all, but its been 3 years since programming in VBA!
Thanks!

 

[SkipVought]

Hi,

CurAfterWitholdingTax the value of -42500

CurPercentWithHoldingTax is 0.23

What is the value of CurGross?



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Big1934]

55000

 

[MichaelRed]

looks more like a " ... Somebody done somebody wrong ... " song.

The math presented does not provide the values.



MichaelRed

 

[Big1934]

well i test the sequence in a regular calculator and got the correct results

gross(55000) * PercentWithholdRate(.23) = taxwithheld

\hmmm

 

[MichaelRed]

so, first post incorrect / incomplete.

possible overwrite of results between your (expected) calc and post?

variables changed elsewhere in process?



MichaelRed