Here are some problems that our users have asked and received explanations on
I am having an issue with an excel formula not returning the expected results. =IF($F2<>"",IF(YEAR(Y$1)&MONTH(Y$1)<=YEAR($F2)&MONTH($F2),$T2,IF(YEAR(Y$1)&MONTH(Y$1)>YEAR($F2)&MONTH($F2),0)),$T2)
Solved by C. D. in 21 mins
I need a formula to calculate a graduated penalty rate: Month 1-3: 1% per month Month 4-6 2% per month Month 7-9 3% Per Month Moth 10-12 4% per month After 12 months total penalty charged 30% After that 1.25% per month
Solved by K. L. in 16 mins
i need a formula to calculate month to month percentage change where the old month is 0 and the new month is 4850. please
Solved by V. B. in 11 mins
I need a formula in excel to concatenate the name of all the people whose birthday is highlighted this month.
Solved by D. E. in 17 mins
i need a formula to convert previous month date as current month