Formula not showing result

J

Joe Gieder

Why would a formula show the formula instead of the
result. I've tried =B4-B5 and see =B4-B5, I've tried
=COUNTA('Priced BOM'!$A$3:$A$301)-COUNTBLANK('Priced BOM'!
K3:K301)-18 and get the formula. What can I be doing
wrong.
Please help

Thanks
Joe
 
N

Niek Otten

Hi Joe,

Probably the cell was formatted as text before you entered the formula.
Format as General and re-enter the formula (F2, ENTER)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
K

Ken Wright

If Niek's reply doesn't do it, make sure you don't have View Formulas checked in
Tools / Options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help On SUMPRODUCT Formula 2
Data Validation - Custom question (multiple conditions) 8
IF formula problem 3
Formula Does Not Omit Criteria 2
Adding on to a formula 2
IF statement using multiple criteria 1
Help please with formula 5
Forumals not showing correct result (unless edit and enter) 0

Top