Trying to do an IF Function so - If value = True then x column by 1.02% however if higher then 1.02% then use this amount. If false then follow on with other IF function.
I am afraid your question is not clear enough. Can you please post some sample data with examples for the several situations that you refer and explain better what you need?