formual calculation

Hello, Issue - Currently my issue is we have recurring expenses that appear every month on the same day of every month. Since we will be processing all payments on Friday we want expenses to recur every month but if the day falls on any weekday besides Friday, I want expenses to occur to next...

Hi Message Board. I originally posted this back in oct 2022 but never got any hits. Could any one help me on this? Just wondering if someone could help/point me in the right direction. Currently, i have some VBA code that copies a range of cells (Q5:DC5 (This the named range called Master_MRP))...

I would like to create a formula to calculate the following Sale Amount Commission $0 - $10,000 8% $10,001 - $20,000 6% $20,001 - $30,000 5% $30,000 + 3% EXAMPLE Sale Amount Commission $25,000 job $1,650 <-- Total First $10K $800 8% of $10K Second $10K $600 6%...

Greetings, I am somewhat lost how to approach this problem that I have. In essence I want to calculate demands per material for specific date based on the number of projects on that date. for this I have 3 tables Project Consumption Table (showing how much of each material is consumed for each...

Hello, I need help formulating. I'm working on an employee attendance sheet. I need to formulate the total hours/minutes missed. If they were Absent it would equal 8 hours; if they Arrived Late the total amount of hours/minutes they missed; if they Left Early the total amount of hours/minutes...

Hi, I need help finding some way out in VBA or just formula .My conditions are : Main column is " D ", if Column J is "Open" then i need next great value from column "C" to column "E" and vise versa .(attached snapshot)

Hello, I want to fill cell e1 with value "GOLD" when I fill cell a1 with value "GL" Similarly if I fill a2 with value "SL" I want the cell e2 to be filled with value "SILVER" I WANT TO FILL A COLUMN CELLS WITH SOME PREDIFENED VALUES AND I WANT CELLS IN E CLOUMN TO GET FILLED WITH ASSOCIATED...

Hello, Might be an easy fix for you Excel experts but I can't seem to get the nested IF formula to return the results I need. The formula would look at number of days and return text as below: Convert the following IFS formula: IFS($AL13<=365,"Within One...

Hi, I have two tables first one is showing number of involuntary resignations each month during 2017, 2nd table resignations during 2018 for locations A,B,C,D,E, F, 3rd table shows the total headcount by month for 2017, and last table is headcount for 2018. My question is: how to calculate...

I have a very large workbook that i need to have open all the time, but I need it to be in manual or else excel/my computer is too slow. During the day I open other workbooks that are normal-sized, and it's annoying that they can never be automatic. Is there a way to have one workbook that is...