Automatic Right Tick (✅) & Cross Tick (❌) in Excel Using IF Formula
Excel is a powerful tool for data analysis and reporting, and sometimes we want to make our reports more visual and easy to understand. Instead of just writing Accept or Reject, you can use Right Tick (✅) for Accepted and Cross Tick (❌) for Rejected records automatically. This can be done easily with the IF formula in Excel.
Formula to Insert Tick & Cross
=IF(C2="Accept","✅","❌")Explanation of the Formula
- =IF(…) → This checks a condition and returns different results based on TRUE or FALSE.
- C2=”Accept” → The condition. If the value in cell C2 is “Accept”, then Excel will return a Right Tick (✅).
- “✅” → Value if the condition is TRUE (Accept).
- “❌” → Value if the condition is FALSE (Reject).
- You can replace “✅” and “❌” with any other symbol, emoji, or even text (like “Yes” / “No”).
- If you want to change the condition (e.g., check for “Yes” instead of “Accept”), just update the formula:
=IF(C2="Yes","✅","❌") - Combine with Conditional Formatting to highlight cells with color for even better visualization.
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
