Solved

All around round

Posted on 2014-03-27
2
237 Views
Last Modified: 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!
0
Comment
Question by:BostonBob
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39960720
"=Round(constants!AO" & i & ",constants!AP" & i & ")"



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.
0
 

Author Comment

by:BostonBob
ID: 39960729
How cool!  I'll try that. Thanks!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The purpose of this article is to demonstrate how we can use conditional statements using Python.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

777 members asked questions and received personalized solutions in the past 7 days.

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

Join & Ask a Question