Triangle Excel formula help

Farmops

New Member
Joined
Mar 13, 2018
Messages
4
Please excuse my ignorance and poor terminology for what I'm about to ask.
I'm working on an Excel spreadsheet for our farm operation. I want to calculate the the distance of A & B when Ba and Cc change linear and lateral. The current pattern is 40" linear and 20" lateral from center line of row. The diagonal distance between the plants is what I'm looking for.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Welcome to the board.

If plants are placed in a rectangular grid with 40' north/south distance and 20' east/west, then they are spaced =sqrt(20^2 + 40^2) diagonal distance (about 44.7 feet).

If that answers your question, you must be planting redwood trees :eeek:
 
Last edited:
Upvote 0
Welcome to the board.

If plants are placed in a rectangular grid with 40' north/south distance and 20' east/west, then they are spaced =sqrt(20^2 + 40^2) diagonal distance (about 44.7 feet).

If that answers your question, you must be planting redwood trees :eeek:

That would be very likely if OP had said Feet, but OP said Inches...;)
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,305
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top