Share via

Calculated if statement in a Word table

Graham Dingley at LawWare 21 Reputation points
2022-01-17T16:13:04.727+00:00

Hi

I have a table in word and I wish to do a calculation in the table

In excel I can do =IF(A1 > 4000, A1 * 1.2, A1 *1.1)

If I try anything similar in Word I get Syntax errors.

Any help greatly appreciated
Regards
Graham

Microsoft 365 and Office | Word | For business | Windows
0 comments
Accepted answer
  1. Emily Hua-MSFT 27,796 Reputation points
    2022-01-18T07:21:49.31+00:00

    Hi @Graham Dingley at LawWare

    Welcome to Q&A forum ~

    Did you insert an Excel object into Word document, or did you use If field in Word document?
    It's better take a screenshot about your formula in Word and the Syntax errors.

    If you use the IF field, pleas refer to JohnKorchok's suggestion, enter the formula in a table.
    One way is go to Insert tab > Text group > Quick Parts > Field > Formula button, then enter the formula.
    165961-capture27.jpg
    165962-capture26.jpg

    The another way, you could press Alt and F9 at the same time, it will go to the Edit Mode for Field Codes.
    Press Ctrl and F9 at the same time to enter {}, then enter the formula inside the curly brackets.
    165954-capture25.jpg
    Finally press Alt and F9 again to switch to normal mode, the result will shown up.
    165943-capture24.jpg

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Korchok 6,416 Reputation points Volunteer Moderator
    2022-01-17T18:20:40.927+00:00

    I'm not seeing any problem with that formula in Word. How are you entering it? Usually, you would create a table, then use Layout>Formula to enter it. Here is your formula in a Word document: Word formula

    1 person found this answer helpful.
    0 comments
  2. Paul Edstein 571 Reputation points
    2022-01-27T11:37:22.997+00:00

    You could use a Word field coded as:
    {=A1*(1.1+(A1>4000)/10)}

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.