View Single Post
  #3   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default IF statement using numerical expression with a text result

Hi covingj,

Press Ctrl-F9 twice to create a pair of nested field braces (ie '{ { } }'), then fill in the space between them so that you end up
with:
{IF{High} 540 "Pass" "Fail")}

For more information on this and a wide range of other calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[MVP - Microsoft Word]


"covingj" wrote in message news
I am trying to create a IF statement that will test a numerical expression
that will result in a text string. Of course I can get this to work in Excel,
but when I put the Excel object into a Word document, it gets ugly when you
go to use it. With my end users, the page can't be changing or they freak out.

Anyway, the statement I'm trying to create in the table would be like so:

=IF (High 540, "Pass", "Fail")

High is a named text field where the user enters a monetary value which is
then tested to determine if the result is pass/fail.

Any help would be greatly appreciated.