for auto rounding try

"=Round(constants!AO" & i & ",log(constants!AO" & i & ")+1)"

you can increase or decrease the +1 to vary the number of significant figures.

Solved

Posted on 2014-03-27

Hi All,

Sorry, couldn't resist the play on words today for this question. :)

This is an extension of my previous question entitled "What is the equivalent?"

I will put that whole question here again and then ask the "All around round" portion of today's question.

Question: What is the equivalent?

"Hi All,

Suppose we have the following script:

(1) "= if(constants!AO" & i & ">constants!AM" & i & ", 1, 0)"

which of course, in lay terms, is just putting in the formula

(2) =if((constantsAO + row))>(constantsAM + row), then 1, else 0))

how would I do the reverse to get this starting with, in lay man terms:

(2) = Round((constantsAO + row), AP),

....where in the column AP there is the corresponding list of significant digits, relevant to the correct row.

Wondering how to get this back into form (1).

(1) = ?

Is there also a way to get it into this form as well?

(1b) = constants.cells(i, "AO").formula? {I know I butchered that, pls be kind}."

Nutsch gave the answer of: "= Round(constants!AO" & i & ",constants!AP" & i & ")"

All around round:

Is there a way for VBA to "detect" how many significant digits there are in a number and automatically truncate the last digit and simply round up or down and incorporate that into (1) as above? In other words, is there a way of not having the "Constants!AP & i" from Nutsch's answer?

I need this to work down a whole column so I will be needing this business of:

constants!AO" & i

Does that make sense?

thanks!

Sorry, couldn't resist the play on words today for this question. :)

This is an extension of my previous question entitled "What is the equivalent?"

I will put that whole question here again and then ask the "All around round" portion of today's question.

Question: What is the equivalent?

"Hi All,

Suppose we have the following script:

(1) "= if(constants!AO" & i & ">constants!AM" & i & ", 1, 0)"

which of course, in lay terms, is just putting in the formula

(2) =if((constantsAO + row))>(constantsAM + row), then 1, else 0))

how would I do the reverse to get this starting with, in lay man terms:

(2) = Round((constantsAO + row), AP),

....where in the column AP there is the corresponding list of significant digits, relevant to the correct row.

Wondering how to get this back into form (1).

(1) = ?

Is there also a way to get it into this form as well?

(1b) = constants.cells(i, "AO").formula? {I know I butchered that, pls be kind}."

Nutsch gave the answer of: "= Round(constants!AO" & i & ",constants!AP" & i & ")"

All around round:

Is there a way for VBA to "detect" how many significant digits there are in a number and automatically truncate the last digit and simply round up or down and incorporate that into (1) as above? In other words, is there a way of not having the "Constants!AP & i" from Nutsch's answer?

I need this to work down a whole column so I will be needing this business of:

constants!AO" & i

Does that make sense?

thanks!

The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**21** Experts available now in Live!