Compare records in IF statement

L

LDanix

Is it possible to use an IF statement to compare two records in an excel
spreadsheet? The document that I want to add this to is already merged with
the spreadsheet. An example of what I am wanting to achieve would be:

{IF "{MERGEFIELD Name}" = "{MERGEFIELD of PREVIOUS RECORD Name}" "2" "1"}

Thanks
 
Top