is someone able to give me a hint or knowledge on how I will calculate
the below.
for example.
If I have a total Sales of 2.5M
then for <=2M the percentage is 30%
then the 500k left is = to 32%
etcccc.
so its like a cumulative calculation based on sales.
so someone like give me a hit on how to IF formula this?
=if(maximum([sales]) = 2M Then .32 elseif( ???
EmilVictor (BOB member since 2019-05-26)