-
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.
formula
- Thread starter Sakurkar
- Start date
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,470
- Office Version
- 365
- Platform
- Windows
If the cells only contain a plus or a minus sign, then this simple formula should work...
=IF(A1=B1,"+","-")
=IF(A1=B1,"+","-")
Upvote
0
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Similar threads
