#1
|
|||
|
|||
if formula in word problems with text
I want to create a formula in a word table..so in a column if there is a value higher or equal with 10 the formula should fill in with the text "exista", if not with "nu exista".. i tryed a lot of formulas but none of them worked... What formula with if should i use? IF(MAX(ABOVE)>=10 , "exista' , "nu exista") is not working..displays syntax error.. Any help?
|
#2
|
||||
|
||||
Try:
{IF{=MAX(ABOVE)}< 10 "nu "}exista Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field construction are all required. To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at: http://windowssecrets.com/forums/sho...Maths-Tutorial or: http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Problems - text turning to gibberish | Dw1 | Word | 4 | 06-17-2015 01:07 PM |
IF Formula problems | mikeb2 | Excel | 1 | 02-17-2015 06:16 AM |
Problems caused by justifying text in Word 2010 | Microsoftenquirer1000 | Word | 2 | 08-11-2013 08:23 AM |
Word 2010 problems with indents, marking text, grammar etc. | adj1 | Word | 4 | 05-08-2012 10:39 AM |
Time as text conversion problems | FraserKitchell | Excel | 4 | 02-25-2010 04:34 PM |