Using IF statement for cell value thresholds

Try

=IF([Total Price Va]=0,0,MAX(10,[Total Price Va]*0.1))
and
=IF([Total Price Va]=0,0,MAX(10,[Total Price Va]*0.09))

Thanks for the help, unfortunately none of the provided solutions work.

To explain the problem better, i need the set up to be 10% of the total price (units*price), if the (units*price) is lower than 10 i need to return the value of 10.

If (units*price) is greater than 10 i need it to return the actual value.

Really appreciate any help!

Works for me, in what way did it not work for you?

Can you post another attachment showing how it returned the wrong result, and what you expect the correct result to be ?

Here it is working as is.

Originally Posted by Jonmo1

Works for me, in what way did it not work for you?

Can you post another attachment showing how it returned the wrong result, and what you expect the correct result to be ?

Here it is working as is.

Hmmm i definitely copied what you have done but didn't work for some reason...

Either way i managed to fix it with the below formula.

Appreciate the help!

Formula:

Please Login or Register  to view this content.

So if there is no value return Zero else check range and return minimum price or the actual value if it is greater than minimum.