Help with a simple formula!

[ChazFr]

Hey
I have a question about a #Value! error... Basically the formula I am using
is this =PRODUCT(A10,E10/B10) or =A11*E11/B11... I just want to know why I am
returning a #Value! error? Is there a solution to make this formula work? I
am trying to basically multiply a quantity of jobs by the cost divided by the
amount of men it takes? Any suggestions?? Thank you!!

 

[Bob I]

place numbers instead of text in A10,A11,E10,E11,B10 and B11.

 

[Bob Phillips]

=IF(AND(ISNUMBER(A11),ISNUMBER(B11),ISNUMBER(E11)),A11*E11/B11,"")

 

[ShaneDevenshire]

Hi,

There is nothing wrong with the formulas, it suggest that some of the cells
do not contain numbers. If they look like numbers but are stored as text the
formulas will fail..

 

[ShaneDevenshire]

Hi again,

I check your formulas and they will work if the cells are formatted as text,
however if any of the cells have been cleared using Spacebar or contain
formulas that return "", you will get the Value error. Also if the cell
contain a number preceeded with or followed by text including a space. Also,
if the data has been downloaded from an external data source you may have a
problem with invisible characters.

 

[ChazFr]

The only cells that contain text are columns C and D... Column C is a drop
down list per cell with "Codes" and Column D is "Code Description"that
automatically fills itself in via the VLOOKUP function when I select a code
from the drop down list in Column C... hmmm this is funky because the cells
the formula is using only contain numbers...

 

[T. Valko]

Another way:

=IF(COUNT(A11,B11,E11)<3,"",A11*E11/B11)

 

[Bob I]

Perhaps they just LOOK like numbers, try clearing the content and rekey
the number in after making sure the cell is formatted as General or Number.

 

[David Biddulph]

Check them with =ISTEXT(A10), =ISTEXT(E10), and =ISTEXT(B10)