![]() |
#1
|
|||
|
|||
![]()
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] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Dw1 | Word | 4 | 06-17-2015 01:07 PM |
![]() |
mikeb2 | Excel | 1 | 02-17-2015 06:16 AM |
![]() |
Microsoftenquirer1000 | Word | 2 | 08-11-2013 08:23 AM |
![]() |
adj1 | Word | 4 | 05-08-2012 10:39 AM |
![]() |
FraserKitchell | Excel | 4 | 02-25-2010 04:34 PM |