Hi All,
I wonder whether anyone here could help me to solve the following issue:
Is it possible to write a formula to get unknown dimension based on the given dimensions but if coordinates of 'P' are on the diagonal line then unknown dimension is zero? I believe, I need a function for the diagonal line which is linked with coordinates of 'P'?
I created a spreadsheet to help with the problem which can be found on the following link:
Kind regards,
Jan
I wonder whether anyone here could help me to solve the following issue:
Is it possible to write a formula to get unknown dimension based on the given dimensions but if coordinates of 'P' are on the diagonal line then unknown dimension is zero? I believe, I need a function for the diagonal line which is linked with coordinates of 'P'?
I created a spreadsheet to help with the problem which can be found on the following link:
Dropbox - File Deleted - Simplify your life
www.dropbox.com
Kind regards,
Jan