Question Re: help with IF statement in Technology Q&A

help with IF statement

zulo — Thu, 23 Feb 2023 05:15:55 GMT

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.

Re: help with IF statement

amitrathi239 — Thu, 23 Feb 2023 07:50:43 GMT

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”

Re: help with IF statement

Yogananda — Thu, 23 Feb 2023 07:51:06 GMT

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", "")

Re: help with IF statement

zulo — Thu, 23 Feb 2023 20:06:41 GMT

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