Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel thinks 7 + 7 + 3 = 18...what gives?
#5
You should get the same answer as if you multiplied the subtotal by 1.2, which is 16,403.676. Rounds to what you got.

If you don't want it to work that way there is probably a truncate function you could use. But I'd rather have it give me the same answer regardless of how I did the math.


Good luck.

- Winston
Reply


Messages In This Thread
Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Winston - 12-05-2009, 05:33 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)