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