Malformed IF Statement

xariet

I have this formula in the multirow tool. Why am I getting error - Malformed IF statement? 

if [ASSET_STREET] = [Row+1:ASSET_STREET] and [Market Value][Row+1:Market Value] and [Subcategory]=[Row+1:Subcategory] then [Market Value] else ([Market Value]+[Row+1:Market Value]) endif

flying008

Hi, @xariet 

Try this.

IF [ASSET_STREET] = [Row+1:ASSET_STREET] and [Market Value] = [Row+1:Market Value] and [Subcategory] = [Row+1:Subcategory]
Then [Market Value]
Else [Market Value] + [Row+1:Market Value]
Endif

IF [ASSET_STREET] = [Row+1:ASSET_STREET] and [Market Value] = [Row+1:Market Value] and [Subcategory] = [Row+1:Subcategory] 
Then [Market Value] 
Else [Market Value] + [Row+1:Market Value]
Endif