help with IF statement

[#1]

Hello SAP experts,

I need some help with IF statement in Lunch Pad 4.3. I'm trying to create calculated column showing letter "G" if value is > 500.

=if([object]>500, "G") - giving me ERROR - Problem converting '500,' to a float.

[amitrathi239]

you need to use semicolon instead of comma in the formula.

=if([object]>500; “G”)

or another way to write if else statement

=if([Object]>500) then “G”

[Yogananda]

zulo
This should work, but make sure your object is a numeric type. If it is a string, you will need to convert it to a number first. Try using the following syntax:

=if(tonumber([object]) > 500, "G", "")

[zulo]

Thank you both, I figures that value was string, so =If(ToNumber([object]) > 500; "G") works with semicolon.