Are you stuck on Excel or Google Sheets?

I am trying to figure out how to use a sumif on SUBSTITUTE(A2,"*","~*") where A2 is a formula with 3371-4

I am working on a cash flow projection. Part of the projection includes sales commissions. Our sales guys earn a monthly draw and then commission on sales after a certain amount. For example they may earn a monthly salary of 12,500 and earn additional commission after their commission equals $150,000. What I need excel to do is sum a column if the values in the preceeding columns are greater than $150,000. I've tried using the sumif and the if function in excel and it's not working correctly either way. Any suggestions?

Question 5. In cell B18, create a formula using nested IF functions and VLOOKUP functions to determine what to do with the returns. Use the lookup table in the Return Data worksheet. Refer to Figure 8-46 for some hints on how to create the formula.

Hi, I have a problem with vlookup formula, I am not sure what am I doing wrong but it seems to not be working

Vlookup or match help, having issues creating the formula

I have an IF statement that works. Its pretty complicated with VLOOKUP. But i need to make this an OR statement and i keep getting errors and can't figure out the formula.

When i do a VLOOKUP, I cannot autofill the formula for the rest of the table. It copies the initial cell that the VLOOKUP was done.

Excel formula returns a lot of #N/A results but unsure how to incorporate the IFERROR function to remove them, Can anybody help? =IF($A3="","",IF(VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE)="","",VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE))) I have removed the link to the sharepoint doc as it gives away the company name so where it says 'SHAREPOINT LINK' just ignore, I don't think anyone needs to know that info. to get the formula to work. Thanks in advance to anyone able to help.

I need to copy a VLOOKUP formula to a cell underneath but instead of moving the third value (B55) to (B56) which happens automatically, I want the formula to move from (B55) to (C55). Basically moving to the next column, not the next row. How do I make this happen?

I need help using VLOOKUP. So I have my formula, and I know its correct but the problem I'm using a name as the lookup value, and the array I'm using has the same entry multiple times. So when I use VLOOKUP I get a #N/A error. How can I adjust this formula to display any one of the results