![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Dear @Chaturvedi, Santosh,
Good day! Welcome to Microsoft Q&A forum!
Based on your description, I understand that when cell C contains a numeric value such as 64.5, the formula correctly returns the desired comment in cells G, H, I, and J. However, when cell C contains "-", you would like the result in those cells to display only "-" instead of generating any comments. You are looking for guidance on how to modify your current formula to achieve this behavior.
From the formula shown in the screenshot: the issue is that ISBLANK() only detects truly empty cells. Since "-" is a text value rather than a blank cell, the formula continues to evaluate the comparison and returns the comment.
Please try updating the formula from =IF(ISBLANK(C1917),"-" to: =IF(OR(ISBLANK(C1917),C1917="-"),"-",
Kindly try and let me know if the results turn out to be like this:
- C1917 = 64.65 > Comment is returned based on the comparison.
- C1917 = 50 > Comment is returned based on the comparison.
- C1917 = "-" > Returns "-".
- C1917 is blank > Returns "-".
Also, could you please confirm whether the value "-" is entered manually into the cell, or returned by another formula?
If the value in column C is generated by a formula, it may actually be returning an empty string ("") instead of a true blank cell. In that case, the formula can be further adjusted to handle blank cells, empty strings (""), and "-" together.
If you can confirm how column C is populated, I'll be happy to help provide the most suitable support for your scenario.
I hope this points you in the right direction. Please let me know if you need further assistance.
Thank you for your time and patience.
If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in [our documentation] to enable e-mail notifications if you want to receive the related email notification for this thread.