Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2015, 10:20 AM
bulangiu23 bulangiu23 is offline if formula in word problems with text Windows 7 32bit if formula in word problems with text Office 2010 32bit
Novice
if formula in word problems with text
 
Join Date: Dec 2015
Posts: 1
bulangiu23 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 12-08-2015, 03:13 PM
macropod's Avatar
macropod macropod is offline if formula in word problems with text Windows 7 64bit if formula in word problems with text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
if formula in word problems with text Word Problems - text turning to gibberish Dw1 Word 4 06-17-2015 01:07 PM
if formula in word problems with text IF Formula problems mikeb2 Excel 1 02-17-2015 06:16 AM
if formula in word problems with text Problems caused by justifying text in Word 2010 Microsoftenquirer1000 Word 2 08-11-2013 08:23 AM
if formula in word problems with text Word 2010 problems with indents, marking text, grammar etc. adj1 Word 4 05-08-2012 10:39 AM
if formula in word problems with text Time as text conversion problems FraserKitchell Excel 4 02-25-2010 04:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft