Hello To All,
Vendors charges us daily rate. End of Quarter - We do Quartey reconciliation and do best rate calculation manually.
I am trying to do best rate formula based on no of day used of that equipment- convert rate Daily to Weekly to Monthly (base on available rate)
Here I attached sample data file. I need help to update formula in column K,L,M to calculate all scenario
Thanks,
Vendors charges us daily rate. End of Quarter - We do Quartey reconciliation and do best rate calculation manually.
I am trying to do best rate formula based on no of day used of that equipment- convert rate Daily to Weekly to Monthly (base on available rate)
Here I attached sample data file. I need help to update formula in column K,L,M to calculate all scenario
Thanks,