Help with IF Function in a table

[news]

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

 

[Graham Mayor]

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 }}" }

 

[macropod]

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/showthreaded.pl?Number=365442

Cheers

 

[drel]

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

 

[drel]

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

drel