0

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

1 Answer 1

0

With the addition of a closing paren for the ISBLANK (just before the first ";") your formula works, at least in locales where ";" is used in place of ",".

=IF(
 ISBLANK( [First Potential Purchasers Selling Price] ) ;
 "0"; 
 TEXT([First Potential Purchasers Selling Price] - [NBV]; "0000000,00")
)

elsewhere it would look like this:

=IF(
 ISBLANK([First Potential Purchasers Selling Price] ) ,
 "0", 
 TEXT([First Potential Purchasers Selling Price] - [NBV], "0000000.00")
)
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.