michaelsmith559
Well-known Member
- Joined
- Oct 6, 2013
- Messages
- 881
- Office Version
- 2013
- 2007
How can I rearrange this equation to solve for A2?
=A2/N2+($J$32*A2)
Thanks,
Mike
=A2/N2+($J$32*A2)
Thanks,
Mike
Before we try to do that, you should fix your formula. Excel calculates the right side of that formula as 9.859096... not as 6.49 as you posted. You may be missing some parentheses, but I am not sure where (I cannot get 6.49 no matter what I do).That didn't work. Here is my formula with values: 6.49=366/56.27012+(0.009166*366) How could this be arranged to solve for 366?
Before we try to do that, you should fix your formula. Excel calculates the right side of that formula as 9.859096... not as 6.49 as you posted. You may be missing some parentheses, but I am not sure where.
With the change you posted in Message #4, it looks like you are missing the two parentheses shown in red below... do you agree?
6.49 = 366/(53.03969+(0.009166*366))
The OP's problem appears to be one of missing parentheses (see Message #6).366/53.03969+(0.009166*366)=10.2552488196224
10.2552488196224/(1/53.03969+0.009166)=366