ATAN Function returns FALSE (when IFERROR added) and DIV/0 when left

This is the formula I am having difficulty with. It works but it leaves the sheet looking scruffy if not filled out correctly. Can anyone help?

=IF([@Exercise]="Hill Sprints",DEGREES(ATAN([@[Elevation (Km)]]/[@[Distance (Km)]])),"")
Returns DIV/0 until Elevation and Distance are filled in.

=IFERROR(IF([@Exercise]="Hill Sprints",DEGREES(ATAN([@[Elevation (Km)]]/[@[Distance (Km)]]))),"")
Returns FALSE

The cells/column where this function is located should leave a blank cell until Hill Sprints is selected in the Exercise column and values are inputted into the Elevation and Distance columns.


Regards

Originally Posted by WideBoyDixon

What about:

Please Login or Register  to view this content.

?

WBD

That is much cleaner. Thankyou. May I ask what is the N for in the formula?