MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

loop in VBA

  Asked By: Darla    Date: Oct 06    Category: MS Office    Views: 1501

I have the following formula B29*(B31-G34)^2/2 =0 Values in B29 and B31
are constant I need to
write a VBA code to unable me to find the Value of G34 so that the formula =0
any one can help



2 Answers Found

Answer #1    Answered By: Alfie Evans     Answered On: Oct 06

Your formula  is

B29*(B31-G34)^2/2 =0

This would be calculated in this order


If that is what you meant

Then for the equation to = 0, B31 and G34 must be equal. It does not matter
what B29 is.

If you meant something else, let us know what you did mean, including the
order of calculation.

Answer #2    Answered By: Tiaan Thompson     Answered On: Oct 06

To resolve the formula  you've given us, either B29 needs to be zero, or B31
and G34 need to contain the same value. A loop  is not needed.

Didn't find what you were looking for? Find more on loop in VBA Or get search suggestion and latest updates.