Result should = 20% or £25 which ever is greater. 1

[SamDemon]

What would be the best way of modifying the following calculation field so that the result is as follows:-

Deposit = 20% or £25 which ever is greater.

This is all I have at the minute:
Deposit: [NetGroupRate]*0.2

Is it possible?

Sam

It's just common sense, shame sense isn't common!

 

[SuicidED]

Hi

IIf([NetGroupRate]*0.2<25,25,[NetGroupRate]*0.2)

 

[SamDemon]

Exactly what i needed!!

It's just common sense, shame sense isn't common!