Panama1182
New Member
- Joined
- Apr 3, 2018
- Messages
- 23
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Need help with a simple formula
- Thread starter Panama1182
- Start date
-
- Tags
- excel formula
SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,503
- Office Version
- 2021
- Platform
- MacOS
Check if this what you are looking for -
| All Records.xlsb | ||||
|---|---|---|---|---|
| B | C | |||
| 4 | Comp Ratio: 37.6% | 37.60% | ||
| 5 | Operating Margin: 58.0% | 58.00% | ||
Sheet5 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B4 | B4 | ="Comp Ratio: "&TEXT(C4,"0.0%") |
| B5 | B5 | ="Operating Margin: "&TEXT(C5,"0.0%") |
Upvote
0
Panama1182
New Member
- Joined
- Apr 3, 2018
- Messages
- 23
This is exactly what I was looking for. Thank you so much!
Upvote
0
SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,503
- Office Version
- 2021
- Platform
- MacOS
Glad to help you
Upvote
0
