Forum

Hello, Welcome to MOTH. It is always better to upload Excel files than Word documents if you have some issues with Excel formulas. But let's giv...

Hello and happy new year! In order to get such rating average you need to calculate like this: 1. Multiply each response total with its rating v...

Hello Sunil, I hope below formula is what you are looking for. =(D4+E4)*IF(DATEDIF(B4,C4,"y")<5,0%,IF(AND(DATEDIF(B4,C4,"y")>=5,DATEDIF(B4...

Hello Charlie, My experience with using barcode and RFID scanners with Excel has not shown any problems other than that you sometimes need to defin...

Hello, I see no error in the attached file, nor do I see any index and match formulas either. Merry Christmas!

Hello, I am not sure I have understood your question correct, but I can at least advice you to not use that kind of data layout when gathering data...

Hello Laura, Welcome to this forum, I am pretty sure you will finf it resourceful. Try changing your formula a bit. As I am currently using a ta...

Hello Dinesh, May I suggest you to consider taking the Excel for decision making course that is available here at MOTH? I haven't taken it myself, ...

Hello Julie, A general answer is to use Power Query for this.

Hello Charlie, Thank you for the additional explanation, I think I have grasped the picture now. As I still assume you need to copy and paste this ...

Hello Charlie, I assume you want some help with TIMES.xls. I also assume that what we see in TIMES.xls is the report output from your time registra...

Hi, It is a nice trick Velouria, I had to play around a little to understand what it does. This is why I like this forum, you get to learn new ways...

Hi Anne, It all depends on how experienced your customer is with creating and using scripts, for example VBA, Command or PowerShell scripts. With s...

Hello, As you mentions, the net value is calculated as: = Order Value - ((One Time Cost * Quantity of Terminals) + (Monthly Cost * (Nr of Months * ...

Hello Tina, What you are showing is a service from a SQL server, also refered to as SSRS. You can read more about it from the link below. You would...