daytona12345
New Member
- Joined
- Aug 31, 2021
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
- MacOS
I'm not even sure what to call this -- I tried googling a couple of ways of phrasing and got nothing.
Essentially what I want to do is reduce the number of separate formulas I have and consolidate to as few as possible (1 is desired).
Right now I have something like:
So if I leave this as is, I'll get : 201,682,132.84
But what I want to do is add my next calculation into the formula inside A2, which would look like this:
the value in B2 would = 0.0001413114766
What I am trying to do is divide the result that B1 would provide...in the same formula, is that possible?
So like: =(A1*2^32/600/1000000000000) / (A2 / result of B1 cell formula)
Something like this wont work, because the order of operations:
=(A2) / (A1*2^32/600/1000000000000)
Essentially what I want to do is reduce the number of separate formulas I have and consolidate to as few as possible (1 is desired).
Right now I have something like:
A1 | A2 |
28,174,668,481,289 | =A1*2^32/600/1000000000000 |
So if I leave this as is, I'll get : 201,682,132.84
But what I want to do is add my next calculation into the formula inside A2, which would look like this:
A | B |
28,174,668,481,289 | =A1*2^32/600/1000000000000 |
28500 | =A2 / B1 |
the value in B2 would = 0.0001413114766
What I am trying to do is divide the result that B1 would provide...in the same formula, is that possible?
So like: =(A1*2^32/600/1000000000000) / (A2 / result of B1 cell formula)
Something like this wont work, because the order of operations:
=(A2) / (A1*2^32/600/1000000000000)