“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

actual - expected calculation in excel steps?

Solved by X. J. in 21 mins

1. Acme Manufacturing makes a variety of household appliances at a single manufacturing
facility. The expected demand for one of these appliances during the next four months is
shown in the following table along with the expected production costs and the expected
capacity for producing these items

Solved by Z. H. in 13 mins

Hi, I am not an excel expert so I need simplistic help. I am trying to calculate on excel when invoices will be paid. we make two payments per month in our office. 1st and 15th.i have expected payment dates and dependant on where they fall is when they will be paid,
an example, if i have an expected invoice date of 12.01.19 this would be paid on 15th, if i have an expected invoice of 27.01.19, this would be paid on the 1st
how to i write a formula toa llow excel to look at my expected date for payment and apply it to either the 1st or 15th of that month or the next

Solved by I. W. in 15 mins

14. Starting in Year 2, Greenways is budgeting 0.22 million for facilities operations. Enter this value in E8. It is expected that these costs will increase on a growth pattern by 6% per year. Use the Excel Series features to extrapolate facilities operation costs for Years 3-15.

Solved by M. Q. in 29 mins

I am using the following formula to return the value of the last entry in a range that is not blank.
=IF(AD14<>"",(INDEX(N14:AD14,MATCH(REPT("z",255),N14:AD14))),"")
However, it is not functioning as expected; it simply returns the value of the last cell in the range.

Solved by Z. S. in 24 mins