hi, im new to the forum and not skilled in excel so i tried to find a simple formula online but got lost in the forest of formula's
what i try to do is fairly simple.
i have an certain amount (lets say 23) in A2 that needs to be split over 3 cells (B2,C2,D2) B2 shows between 0 and 10, C2 shows bigger then 10 but not bigger then 20 and D2 shows everything bigger then 20. so in this example it would look like this:
A2=23... B2=10 C2=10 D2=3
Bookmarks