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