in excel how can I get the number to show instead to #value in th.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in excel how can I get the number to show instead of #value in the cell where
I used a formula
 
Hi!

#VALUE! means the formula is returning an error. You're
using an improper data type in the formula.

Post the formula with a detailed explanation of what it is
you're trying to do.

Biff
 
Not much to go on here but a couple of guesses.

If the formula is an array formula it must be entered using CTRL + SHIFT +
ENTER or you will get the error.

If one or more of the values is not really a number, you will get the error.

If any of the referred to cells has a formula with an error you will get the
error.

Perhaps post a sample(not a file) of your data and formula.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Excel How to get output of the formula instead of True or false 1
Match function: error due to format? 4
Red cell for negative numbers in Excel 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Why does forumula show in cell instead of formula result? 2
Displaying zeros in cells 2
Count entries in the column translating to minutes. 5

Back
Top