I have a simple spreadsheet that has two inputs...Distance and Time.
I want to display two possible results in the third cell...either Minutes per Mile or Speed.
The problem is Min/mile is in TIME format while SPEED is in number format.
How do I have dual formats in this cell depending on whether the column title reads Min/Mile or Speed?
I have the formulas for Min/Mile and Speed already calculated based on the column title.
If column C title reads Min/Mile, then format is in TIME format
If column C title reads Speed, then format is in NUMBER format
Thanks
Lance
I want to display two possible results in the third cell...either Minutes per Mile or Speed.
The problem is Min/mile is in TIME format while SPEED is in number format.
How do I have dual formats in this cell depending on whether the column title reads Min/Mile or Speed?
I have the formulas for Min/Mile and Speed already calculated based on the column title.
If column C title reads Min/Mile, then format is in TIME format
If column C title reads Speed, then format is in NUMBER format
Thanks
Lance