THIS IS MY PROBLEM, I HAVE:
H2) =IF(G2="","",G2*H2) THIS FORMULA WORKS FOR ME BUT HERE IS THE PROBLEM
I HAVE A CELL WHERE I HAVE L2 )=G1-H1-I1-J1+L1 IT GIVES ME VALUE ERROR
BUT IF I CHANGE H2) TO =A1*B2 WORKS FINE THE ONLY PROBLEM THIS WAY IS THAT I
GET THE SAME NUMBER ALL THE WAY DOWN MY SHEET.
CAN ANYONE HELP ME PLEASE? HOW CAN I FIX THAT VALUE ERROR!
T.K

Firstly, please do not post in All Caps. It is very hard to read and is
considered rude to do so.
The formulas don't seem to be relative to each other, so it might be worth
looking at the cell references in L2 to see if any of them are formatted as
something other than numbers, say text for example.

HTH
Michael M

"anier614" wrote:

THIS IS MY PROBLEM, I HAVE:
H2) =IF(G2="","",G2*H2) THIS FORMULA WORKS FOR ME BUT HERE IS THE PROBLEM
I HAVE A CELL WHERE I HAVE L2 )=G1-H1-I1-J1+L1 IT GIVES ME VALUE ERROR
BUT IF I CHANGE H2) TO =A1*B2 WORKS FINE THE ONLY PROBLEM THIS WAY IS THAT I
GET THE SAME NUMBER ALL THE WAY DOWN MY SHEET.
CAN ANYONE HELP ME PLEASE? HOW CAN I FIX THAT VALUE ERROR!
T.K

You must have some typos in your post aside from forgetting to turn off your
Caps Lock.

This formula =IF(G2="","",G2*H2) cannot possibly work in H2 without a
circular reference error.

Where does L2 come into the equation?

As far as same value all the way down, perhaps you have calculation set to
manual?

Please re-post without the Caps.


Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 15:54:00 -0700, anier614
wrote:

THIS IS MY PROBLEM, I HAVE:
H2) =IF(G2="","",G2*H2) THIS FORMULA WORKS FOR ME BUT HERE IS THE PROBLEM
I HAVE A CELL WHERE I HAVE L2 )=G1-H1-I1-J1+L1 IT GIVES ME VALUE ERROR
BUT IF I CHANGE H2) TO =A1*B2 WORKS FINE THE ONLY PROBLEM THIS WAY IS THAT I
GET THE SAME NUMBER ALL THE WAY DOWN MY SHEET.
CAN ANYONE HELP ME PLEASE? HOW CAN I FIX THAT VALUE ERROR!
T.K

i forgot to turn off my caps, sorry, you consider this offensive and rude.
u are one sensitive case.

"anier614" wrote:

THIS IS MY PROBLEM, I HAVE:
H2) =IF(G2="","",G2*H2) THIS FORMULA WORKS FOR ME BUT HERE IS THE PROBLEM
I HAVE A CELL WHERE I HAVE L2 )=G1-H1-I1-J1+L1 IT GIVES ME VALUE ERROR
BUT IF I CHANGE H2) TO =A1*B2 WORKS FINE THE ONLY PROBLEM THIS WAY IS THAT I
GET THE SAME NUMBER ALL THE WAY DOWN MY SHEET.
CAN ANYONE HELP ME PLEASE? HOW CAN I FIX THAT VALUE ERROR!
T.K