Search results

Hey Ken, Really appreciate your help. It worked great. Again thanks for your help.

Hello, Is it possible to get some help in solving my conditional formatting problem. I have attached a sample sheet with desired result. if current profit < expected profit by 10% highlight cell with Red if current profit >= expected profit by 10% highlight cell with green Thanks for your help.

Hello Gurus I have a table in Postgresql database that has duplicate values and I want to calculate target_sales based on sales_id column. I am looking for a measure using DAX. Desired Result should be sales_id target_sales 10 3,000,000 11 4,500,000 7 2,500,000 8 3,500,000 9...

Please attach the dataset

Thanks Peter. Really appreciate your help

Really appreciate your help with the solution

Thanks GraH, I didnt notice the Employee 12 with $14,000 and you are correct. I am trying to calculate estimated state payroll. Usually the estimated wages are much higher than $14,000. Thanks for providing the solution.

Hello Gurus I am trying calculate state payroll taxes based on 3 states with different tax rates and wage thresholds. As an example for California state unemployment taxes are calculated on the first $7000.00 of employee wages. I have attached a sample worksheet with desired output. Really...

Indian Currency 1,00,000 (1 Lakh)

Hello pecoflyer, Really appreciate taking your time to solve this. Thanks for your help

Hello Gurus, I have a spreadsheet that tracks paid time off accrual rate, paid time off and the balance of leave. Column C (PTO Accrual Rate (Per Pay Check) and I want to show 0.77 when employee's get paid as per Pay Date (Column B). For example, if today is 07/27/2020 then it should 0.77. For...

Hi Pecoflyer, Really appreciate your help and input. You formula also worked. Thanks again

Hello Alan, Really appreciate your help. Thanks for taking your time to solve my issue

Hello Gurus, I have over 9000 rows in my excel spreadsheet and I am trying get the regular hours and overtime hours. I have 1 column with total hours and I want to separate regular hours and overtime hours. I tried both IF AND and IF OR to get Reg Hours and Overtimes but didnt get the right...

Thanks Bosco, Really appreciate taking your time on this issue

Hello GraH, Really appreciate taking time to solve my issue. Your formula also worked

Hello Rahul, That worked. Thanks for your help. Really appreciate your inputs

hello gurus, Can I get help in calculating target hours for each day using the date column and holiday list. In the excel spreadsheet example, I am trying to get 8 hours each day, but if it is a holiday it should be ZERO hours. If it is a Sunday or Saturday it should be ZERO hours Thanks for...

Hey vletm, I was opening it in excel. I opened it in txt now and it works. Really appreciate your help

Hello vletm, When I open the modified file the date format is still mm-dd-yyyy

Hello vletm, We use Odoo erp application and we have to upload a csv file to do bank reconciliations and the csv file date format should be mm-dd-yyyy, otherwise we cannot upload the file. Thanks

Hello Gurus I am trying to change the date format in a CSV file to this date format mm-dd-yyyy (06-18-2020). I have to upload a file every week that has a lot of rows. How can I change the date format each time before I upload the file. I used the format cells and custom format and typed in...

Hello Somendra Really appreciate your help.

Hello Fluff13, That worked. Really appreciate your help. Thanks again

Hello Experts I am trying to find out the number of working days under 2 scenarios 1. if employee has a hire date and termination date, then excel should calculate the number of working days 2. if the employee only has a hire date, then excel should calculate the number of working days till...