Earnings Cap using IF statement in Formula Tool

[KSBurnett]

I'm trying to put an earnings cap in a WF that will cap anything over $20,000 at $20,000

I created a new column Called Total Sales and have the following IF statement

IF [Total Sales Credit] > 20000 THEN [Total Sales Credit] = 20000 ELSE [Total Sales Credit] ENDIF

Data type going in and coming out is Double

This statement results in anyone with earnings over $20,000 getting a $0 value instead of $20,000

I also tried putting () around my conditions but that changed nothing.

Help!

[MarqueeCrew]

@KSBurnett ,

 how about trying this expression in a formula:

MIN ([Total sales credit],20000)

 cheers,

 mark

[Emil_Kos]

Hi @KSBurnett,

Please try:

IF [Total Sales Credit] > 20000 THEN  20000 ELSE [Total Sales Credit] ENDIF

[Tyro_abc]

Spoiler

Please check this formula..

Spoiler

IIF([Amount]>=20000,20000,[Amount])

Regards 

Arundhuti