mtlbooksCopper ContributorAug 24, 2022need help on a fomula there is a way to calculate a cell substract the whole column above?
mtlbooksCopper ContributorAug 24, 2022thanks! but I didn't specify my problem well I want in cell N6 a formula something like this: =m6-(the last entry in this column [in this case it's in m3])*L6 [in this case it should come out337.5]mtarler
mtarlerSilver Contributor to mtlbooksAug 24, 2022assuming you have excel 365:=(M6-XLOOKUP(1,--(M$1:M5>0),M$1:M5,0,0,-1))*L6
