express

Hi, I was trying to use IF, AND, OR formula to build the condition below but I'm not sure why it's not working. The condition should be: if Category is high or Critical and Status is Express then it's TRUE, otherwise False. The results column is the desired results. Category Status Results...

I want to create a 'Totals' column (column C) that will count certain values twice. How do I express the following as a formula: C1 = (A1 x 2) + B1

Let say I have a function like: SUMPRODUCT((A1:A5)*(B1:B5)*(C1:C5)*(D1:D5)*(E1:E5)) Is there a shorter way to express the range from column A to E?

I have data & PowerQuery in Excel and I wish to store data in SQL Server Express instead. How to do that ? In addition, should I keep PowerQuery in Excel, or actually we could use SQL Server Express to do the PowerQuery job ? Please advise. Thanks

Hello All, I am trying to change my VBA codes to make more user friendly by giving the users ability to determine the start and finish of the ranges. The code that is already working is like this: Sub Test() Worksheets("Express").Activate...

Hello friends, I am new here but i need your help for a excel sheet that i am making. I have the City and the Weight in one sheet. In the other sheet, theres the cities, all weights and the costs. In the first sheet, we can select the City and the weight. I want to show in that same sheet the...