View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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