Reply
 
Thread Tools Display Modes
  #1   Report Post  
news
 
Posts: n/a
Default Help with IF Function in a table

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


  #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



  #3   Report Post  
macropod
 
Posts: n/a
Default

Hi,

Try:
{=55*C2 \# ,0.00;-,0.00;}
The empty third argument in the numeric picture switch suppresses ) output.

For more information on Word field maths and the associated switches, see:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Cheers


"news" wrote in message
...
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




  #4   Report Post  
drel
 
Posts: n/a
Default

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





  #5   Report Post  
drel
 
Posts: n/a
Default

thanks for the link to the doco. we read it end to end

drel


"macropod" wrote in message
...
Hi,

Try:
{=55*C2 \# ,0.00;-,0.00;}
The empty third argument in the numeric picture switch suppresses )
output.

For more information on Word field maths and the associated switches, see:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Cheers


"news" wrote in message
...
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






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table headers/footers and layout Keith Page Layout 1 April 8th 05 07:37 PM
How to Avoid Word 2003 Table Style Problems Judy Haynes Tables 0 March 23rd 05 07:41 PM
Table AutoFormats vs. Table Styles confusion Tony Jollans Tables 5 March 6th 05 08:18 PM
if () function in table Bg Tables 1 February 1st 05 01:06 PM
Why there is no Table of Authorties function in my Word 2003 Joey_lim Microsoft Word Help 1 January 20th 05 05:07 PM


All times are GMT +1. The time now is 04:07 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"