Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table headers/footers and layout | Page Layout | |||
How to Avoid Word 2003 Table Style Problems | Tables | |||
Table AutoFormats vs. Table Styles confusion | Tables | |||
if () function in table | Tables | |||
Why there is no Table of Authorties function in my Word 2003 | Microsoft Word Help |