Thanks for the try Graham, but it's still not working right, leaves a blank
field no matters whats in C2, C2 normally pulls it's info from the a
maximizer database but i don't think that is the issue, have tried using
standard data in C2 to no avail, the reason i was using the 50/10*11 was
because i was calculating GST of a maintanance price for customers dirived
from the same database but in C3, would have read like (C3/10)*11, but now i
am going to make all the pricing the same, should now read like =55*{C2}.

drel


"Graham Mayor" wrote in message
...
Bookmark the content of the cell (not the cell itself) and then the
formula

{ IF{ C2 } "0" "{ =((50/10)*11)*{ C2 }}" }

will work


Is there any reason why you are using 50/10? Why not simply

{ IF{ C2 } "0" "{ =5*11*{ C2 }}" }


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

news wrote:
hello all,

this may have been asked before,

I am trying to have a field in a table show upas blank if there is no
value in the cell to the left (or C2), if there is a vaule to do a
calculation based on what is in the cell,
what i have so far is :

{IF C2 = 0 "" ((50/10)*11)*c2}

which does not work, any advice would be great !!

drel