Combining SQRT/ATAN with the IF function and possible Pivot Chart Use

[aabbey]

Please see attachment for comprehensive explanation. If the answer can be attached on the same file and sent back that would be ideal, although any help is appreciated.

[FlameRetired]

Hi aabbey. Welcome to the forum.

Try in F5 and fill down

Please Login or Register  to view this content.

Then I believe you want the ASIN of Elevation/Real Distance.

In G5 and filled down

Please Login or Register  to view this content.

Then part 2 the graphs. I'm not sure I understand this part. I will need to study it. So part 1 is all I have so far in the attached.

[aabbey]

Thank you That was really helpful.

[FlameRetired]

You are welcome. Glad to help.

Have you made progress with part 2? I haven't managed to come up with anything.