MS Word using the IF function.

Question

Hello All:

I am working on a simple table I created on my Word document. What i am trying to de is compare an number I input to another nu,mber that is the standard and already seated in the table. I am using cell identifiction as A,B,C etc for the columns, and 1, 2, 3 etc for the rows. So upper left cell would be R1C1,

My standard/Reference is in location C4R1 and I want to compare it to my input in C1R1. The resule will be in C2R1.

C1R1 contents are 2.54E-11

C4R1 contents are 3.12E-12

My formula =IF (C1R1<C4R1,1,0) Placed formula in C2R1 cell.

I have tried this in Excel and it works fine, and it works in a Work Table fine. BUT what I a trting to do is get a text result output.

This works fine in Excel =IF (C1R1<C4R1,"Pass","Fail") (using excel cell ID instead of R and C)

But will not work on the Word Table.

Would appreciate any assist.

Bob

Answer 1

Use

{ IF { = A1 } < { = D1 } Pass Fail }

You must use CTRL+F9 to insert each pair of field delimiters { } and ALT+F9 to toggle off their display.

As an alternative, you could use { = A1 - D1 # "Fail;Pass" }