delete delete
delete delete
Last edited by NICK SHAY; 10-07-2016 at 03:13 PM.
In the future please include a sample workbook. People are more likely to work a problem when they have something concrete to work with.
Assuming that the aspect ratio is in row 1 and your data starts in Cell A3
The formula in cell B3 would be =$A3*B$1 - this formula can be copied to each cell where you need the information.
Read up on relative and absolute referencing. The dollar sign ($), "locks" that part of the reference, so when you copy the formula to cell C3, it becomes =$A3*C$1. The "A" is locked no matter what column you are in the 3 remains the same since we didn't change rows, The "B" changed to a "C" since it is not locked.
Likewise when you copy down to Cell B4, the formula becomes = $A4*B$1. The "A" and "1" don't change because they are absolute, but the row associated with the formula does change since it is relative.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
remove please
Last edited by NICK SHAY; 10-07-2016 at 03:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks