how to use ratio in excel

so if a ratio of like 0.5:1. how can i set it so if i enter a number like 2.5 in a column it auto calculates and enter a number in another column