K3 Documents

Nested IF Statement

Updated on

Copy and Paste the following formula using your data where necessary.

({Field 1 (REF)}.equals({Field 2 (REF)})) ? {SetBasedonField 3 (REF)} : {SetBasedonField 4 (REF)}
Click to copy
Previous Article Absolute Value
Next Article Add/Subtract Time to a Date