Thread: [Solved] Table Calculations, VBA
View Single Post
 
Old 12-14-2013, 01:40 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Suze,

Maybe I'm missing something here, but when you say:
Quote:
Column 5 must be A+B/B and Column 6 must be A+C/C
that seems to me to be the same as"
"Column 5 must be A+1 and Column 6 must be A+1".
After all, mathematically, B/B = 1; and C/C = 1.

Of course, if as per your code you meant to say:
"Column 5 must be (A+B)/B and Column 6 must be (A+C)/C",
then you have a problem if B=0 or C=0. The problem is that you can't divide by 0 (well, you can, but the result is infinite).

Please clarify.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote