I keep getting syntax errors for This calculated column
IF(ISBLANK([First Potential Purchasers Selling Price];"0"; TEXT([First Potential Purchasers Selling Price] - [NBV];"0000000,00"))
im trying to simulate
if(First Potential Purchasers Selling Price == null)
display 0
else display (First Potential Purchasers Selling Price - NBV)
any help will be appreciated