MIKE H, You are right, actually, I have set formulas into A2 and B2,

In A2 , ='sheet2'!F2 , THAT MEANS THE SOURCR OF A2 IF FROM F2 OF SHEET2
In B2 , ='sheet2'!G2

"Mike H" wrote:

Hi,

I don't understand this. If A2 & B2 are empty your formula will show 0
(Zero) the only way it will show a #value! error is if there are text entries
in these cells. How do data get into A2 and B2? are they formulas?

Mike

"Wu" wrote:

There are three column contain "Quantity" (A1), "Unit price" (B1) and
"Amount" (C1)

I have set a formula at "Amount" (C2)that =A2*B2, it is work , but if
anyone
of A2 or B2 is no data, or both of them are no data, C2 will show
#value!

How can it does not show #value! even there are no data at A2 and B2.

Hi,

No need to start another thread. The answer is the same, there must be text
in those cells on sheet 2. It could be spaces that you don't see as a result
of your formula but are still there.

Try this on a cell that 'looks' to be empty
=LEN(A2)

If it isn't 0 then there's something in the cell.

Mike

"Wu" wrote:

MIKE H, You are right, actually, I have set formulas into A2 and B2,

In A2 , ='sheet2'!F2 , THAT MEANS THE SOURCR OF A2 IF FROM F2 OF SHEET2
In B2 , ='sheet2'!G2

"Mike H" wrote:

Hi,

I don't understand this. If A2 & B2 are empty your formula will show 0
(Zero) the only way it will show a #value! error is if there are text entries
in these cells. How do data get into A2 and B2? are they formulas?

Mike

"Wu" wrote:

There are three column contain "Quantity" (A1), "Unit price" (B1) and
"Amount" (C1)

I have set a formula at "Amount" (C2)that =A2*B2, it is work , but if
anyone
of A2 or B2 is no data, or both of them are no data, C2 will show
#value!

How can it does not show #value! even there are no data at A2 and B2.

I'm not sure what your question is, but I'm thinking you need to go back and
look at the values in these cells.

'Sheet2'!F2
'Sheet2'!G2

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Wu" wrote:

MIKE H, You are right, actually, I have set formulas into A2 and B2,

In A2 , ='sheet2'!F2 , THAT MEANS THE SOURCR OF A2 IF FROM F2 OF SHEET2
In B2 , ='sheet2'!G2

"Mike H" wrote:

Hi,

I don't understand this. If A2 & B2 are empty your formula will show 0
(Zero) the only way it will show a #value! error is if there are text entries
in these cells. How do data get into A2 and B2? are they formulas?

Mike

"Wu" wrote:

There are three column contain "Quantity" (A1), "Unit price" (B1) and
"Amount" (C1)

I have set a formula at "Amount" (C2)that =A2*B2, it is work , but if
anyone
of A2 or B2 is no data, or both of them are no data, C2 will show
#value!

How can it does not show #value! even there are no data at A2 and B2.

Hi,

Two things:
1. Try moving to those empty cells and press Del. The cells may contain
spacebars.
2. Don't breakup a thread because it's a pain for us to track it down, even
worse when it has a new name which is so informative - "Help! Mike H"

--
Thanks,
Shane Devenshire


"Wu" wrote:

MIKE H, You are right, actually, I have set formulas into A2 and B2,

In A2 , ='sheet2'!F2 , THAT MEANS THE SOURCR OF A2 IF FROM F2 OF SHEET2
In B2 , ='sheet2'!G2

"Mike H" wrote:

Hi,

I don't understand this. If A2 & B2 are empty your formula will show 0
(Zero) the only way it will show a #value! error is if there are text entries
in these cells. How do data get into A2 and B2? are they formulas?

Mike

"Wu" wrote:

There are three column contain "Quantity" (A1), "Unit price" (B1) and
"Amount" (C1)

I have set a formula at "Amount" (C2)that =A2*B2, it is work , but if
anyone
of A2 or B2 is no data, or both of them are no data, C2 will show
#value!

How can it does not show #value! even there are no data at A2 and B2.