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

E

excel

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

Biff

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
 
G

Gord Dibben

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
 

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

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Excel Countif Function - Calculating Between Two Sets of Values 3
Is there a function to count how many times a cells value is used? 0
Formatting question: how to format duration (time spent)? 0
Mac Excel 2011 and MS Excel 2007 #N/A 0

Top