modernmind
New Member
- Joined
- Aug 28, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Here is my formula: =IF(C45="","",(M45/M45)&":"&ROUND(AB45/M45, 2))
This will round the result to two decimal places but does not add a decimal and two zeroes which would allow
all ratios to line up in the column. Attached is an image of the column.
Tried formatting all sorts of ways but that was not successful. Appreciate help.
This will round the result to two decimal places but does not add a decimal and two zeroes which would allow
all ratios to line up in the column. Attached is an image of the column.
Tried formatting all sorts of ways but that was not successful. Appreciate help.