Hi

Don't post your file to the NG.
If you want to send me a copy of the file directly, I will take a look
at it for you.

Remove NOSPAM from my email address to send direct

--
Regards

Roger Govier


"alen_re" wrote
in message ...

Even with your great instructions I just cant get it to work...
I've formated the cells in T column as numbers, but it doesn't work...

The numbers in T column are also from a formula that calculates the
margin on some products.. and in cells in this column, if I don't have
other values to calculate the margin.. I get #N/A.. usually I have
problems with formulas if I have #N/A in some cells.. So i tried to
hide N/A under T columns with this formula:
=IF(ISNA(YourFormula),"",YourFormula)
but when I do this.. I dont get a value in T cells... this is freaking
me out...

Would anyone help if I upload my file ?!


--
alen_re
------------------------------------------------------------------------
alen_re's Profile:
http://www.excelforum.com/member.php...o&userid=28331
View this thread:
http://www.excelforum.com/showthread...hreadid=506593