This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello. I need help with an Excel formula. Example below:
Cell e15 shows 100 mcfd
Cell b15 shows 80 mcfd
I need cell f15 to calculate the difference between the two, which would be 20 mcfd. However, i keep getting an error and I’m assuming it’s because of the “mcfd” not being a number.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Option 1:
Enter 80 in B15 and 100 in E15.
In F15, enter the formula =E15-B15.
Apply the custom number format
0 "mcfd"
To B15, E15, F15 and all other cells with similar data.
Option 2:
Enter the following formula in F15:
=SUBSTITUTE(E15, " mcfd", "")-SUBSTITUTE(B15, " mcfd", "")&" mcfd"
Perfect! Thanks for the help. Option 2 did the trick for me.