Lets say I have a figure of 45; the first 25 I want to divide by 50% and the rest divided by 75% - how can I do that in one cell? (or with help from cells in hiddin columns etc).
50% of the first 25 = 12,5 75% of the rest (20) = 15
Sum of the above = 27,5.
My end goal is to produce a column that gets me 27,5 (and even better; multiply this number by another number)
I tried various combinations of IF statements. I have tried to calculate each step in separate columns - but I don't know how to take part of an absolute number to calculate
Not really any code would make sense, as they have not even come close to yield desired outcome.
FALSE (I was supposed to wright something here, but I have no clue how to even begin the formula)
Aucun commentaire:
Enregistrer un commentaire