#if #and

Hi everyone, This IF AND formula does not seem to be working and i can't figure out why. Can someone please help? thANK YOU. =IF(AND([@Type]="income",shift_late_income_status="Active",DAY([@Date]>=shift_late_income_starting_day), DATE(YEAR([@Date]),MONTH([@Date])+1,1), [@Date]))

Hi Everyone, I am trying to figure out how to find out when a client on my clientele list first visited our shop. Below is a sample table to give you an idea of what the clients list would look like and the date format that I am currently using. ABCDEFGHI1Client NameDatePaymentUnique...

So I am stuck and I know this has to be an easy fix... I have always used this forum (for years) because it actually has smart people running it! Could anyone help? Sheet1 contains the following data starting at row 9 (to row 80): Bid Unit Short Description Unit Qty Unit Rate (1) Total Long...

Hey Team! Im stuck on a excel problem. Wonder if someone could give me some advice? Its a simple scenario, but Im having trouble with the function. Lets say you are going to get paid out based on the performance if your company. So any net income over $425,000 but under $725,000 you get 100%...

Hi, I hope the image above isn't too small. The browser crashed when I tried pasting the section of Excel directly. You will see above that there are two different formulae - one that is simply asking the commissionable value column to return the lowest number between columns B and D, and to...