if statement multiple conditions

[SyP]

Dear All,

I'm trying to create the next formula :

Every dealer can buy tyres at any quantity,         

but when he has a minimum of 30 tyres he gets 6 points

but when he has a minimum of 60 tyres he gets 12 points

but when he has a minimum of 90 tyres he gets 18 points

etc….

How do we translate this into one formula or do you replicate the formula depending on the condition ?

[atcodedog05]

Hi @SyP 

Formula would be

IF [no tyres]=>30 and [no tyres]<60 Then "6 points"

ElseIF [no tyres]=>60 and [no tyres]<90 Then "12 points"

ElseIF [no tyres]=>90 Then "18 points"

Else Null() Endif

If you provide sample data and expected output we can help you out.

Hope this helps : )

[danilang · Accepted solution]

Hi @SyP 

If your field is called [TyresBought] then you can use the following formula

floor([TyresBought]/30)*6

The Floor() function returns the closest integer less than or equal to its argument

Dan

[atcodedog05]

Agreed in this usecase @danilang method makes it easy and more sense 🙂