Display a Ratio
To have a value show as a ratio 5.0:1 you can use a custom number function.
The value in the cell is 5, but it displays as 5.0:1. This means you can still do calculations and comparisons with the value.
The format is
0.0":1"_)
To have a value show as a ratio 5.0:1 you can use a custom number function.
The value in the cell is 5, but it displays as 5.0:1. This means you can still do calculations and comparisons with the value.
The format is
0.0":1"_)
Please note: I reserve the right to delete comments that are offensive or off-topic.