If function error

I am returned the error "Parse error at char (11)" and am unsure what it means and how I resolve it?

The formula used is IF [Earned]=<[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

All variables are in double format.

The formula is trying to calculate the triangular number sequence based on n = earned up until a limit of 365 (total number of days in the year). At which point the output should always be 365*(365+1)/2 = 66795

Developer

Error Message

Accepted answers

Emil_Kos

Hi @FECL3,

At first glance it looks like you need to make just a small change in your formula:

IF [Earned]=<[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

It should be

IF [Earned]<=[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

All comments

Emil_Kos

Hi @FECL3,

At first glance it looks like you need to make just a small change in your formula:

IF [Earned]=<[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

It should be

IF [Earned]<=[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

Billigans

The error message is telling you that something is wrong at the 11th character in your string. In your case, it doesn't understand the "=<" part. Try flipping them around, like below. That should fix that error, at least.

IF [Earned]<=[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

atcodedog05

Hi @FECL3

Change the formula to below

IF [Earned]<=[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

Hope this helps : )

Billigans

Hello Friend, if you found the answers to your question helpful, be sure to accept them as a solution. Happy Solving!

grazitti_sapna

Hi @FECL3 , there is a minor mistake in your formula,

IF [Earned]=<[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

Replace the formula with,

IF [Earned]<=[Duration] THEN ([Earned]*([Earned]+1))/2 ELSE (365*(365+1)/2 ENDIF

If this works, kindly mark it as a solution if this solves your purpose.

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703