Soldato
- Joined
- 10 Apr 2004
- Posts
- 13,497
I currently have a formula like this:
I need it to look like this:
However, X2 is a changing row number from X2 onwards.
How do I get excel to find each incorrect line (regardless of the row number after the X) to the correct formula along with the correct row number?
So:
goes to
Cheers!
Code:
('Stage 1 T-O'!$AA*9.81-X2)I need it to look like this:
Code:
(('Stage 1 T-O'!$AA-(X2*0.45359237))*9.81)However, X2 is a changing row number from X2 onwards.
How do I get excel to find each incorrect line (regardless of the row number after the X) to the correct formula along with the correct row number?
So:
Code:
('Stage 1 T-O'!$AA*9.81-X999)
Code:
(('Stage 1 T-O'!$AA-(X999*0.45359237))*9.81)Cheers!