if formla

I want to add the ROUND function in the below code. ROUND(L8,0) L8 =IF(I8>=2,2*13500,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8)))))))

Hi there I really need some help with a formula that has been frustrating me for days :confused: so really hoping someone here will be able to help me out. I have two columns of data with "Yes" or "No" in them - one column represents if a task has been started (column A), the other represents...

I have multiple options combined in a column and want to analyse that data. e.g. there are options Education of children, marriage of children None Education of children, Marriage of Children, Business Start-Up Education of Children, Land Purchase for House Construction, Home Construction...

I'm trying to write a nested IF formula that the first argument looks at a particular cell and is supposed to find any value other than Yes or Discontinued. I've put in my logical test =if(or(A1<>"Yes",A1<>"Discontinued"),True Statement,Further IF Formulas). On the cells that contain Yes or...

Hi Again, Struggling to come up with a solution to the following. Im looking to create an IF formula for the following situation. If another worksheet has the same value as the current worksheet then display the corresponing cell value of the other worksheet that lies in that row. The range...

I have a spreadsheet of approximately 20,000 rows and 50 columns. In Column C I have a list of SKUs that look like the following. 10001 10001B1 10001B2 100001B3 100002 100003 100003B1 100003B2 100003B3 100003B4 and so on. The B1,B2, etc are for additional boxes. The highest it goes up to is...