|You still have not answered my question. The main issue is that you are not copying the formulas from your spreadsheet into your posts, you are typing invalid formulas into your posts and that is causing confusion.|
e.g. this formula will not work unless a & b are Named Ranges. Therefore, a & b must be something else and that is what I am asking about.
From now on, please try to use actual formulas that will work if pasted into Excel. When I say "work" I mean that the syntax is correct, not that they necessarily return the value you are expecting. I can't test a formula when the syntax is not correct, so I have to rewrite them based on how I think they should be which may not be how you think they should be.
I will try one more time....
Using a & b in your explanations is a major part of the confusion. a & b can not be used in a formula unless they are Named Ranges, which I assume they are not. Therefore, this formula is invalid:
Here are my specific questions:
How are the values for a & b getting into the actual formula that you are using in the cell? Are a & b numbers that you are entering manually once the other formula has calculated them are or you referencing the cell that contains the result of the other formula?
For example, using A1 and B1 as example cell references...
A1 contains =ROUND(373/357,3) therefore A1 displays 1.045
Now that you have 1.045 in A1, which of these 2 formulas are you using in B1:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.