# cos

1. ### Need to add or function to if function

I have the following formula in Col G =IF(LEFT(B2,2)="UC","COS",IF(AND(B2="F22200",F2=""),"COS",IFERROR(VLOOKUP(F2,'unique Suppliers & Codes'!A:B,2,FALSE),""))) I would like the formula amended so that if Col F contains a date format dd/mm/yyyy for eg 03/04/2018 then it must return COS in...
2. ### Use index/match and sumifs to get a report which can be done on pivot table

Is it possible to use a formula to return the result as per below: <colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="112" style="width: 84pt...
3. ### VBA Code: Copy Column down to match with text in the next column

Hello, I am not sure if I can use a formula or a VBA code to do this task. <colgroup><col width="64" style="width: 48pt;"> <col width="325" style="width: 244pt; mso-width-source: userset; mso-width-alt: 11885;"> <col width="287" style="width: 215pt; mso-width-source: userset; mso-width-alt...
4. ### Measure calculation for Individual items in Colums

Hello everyone, I am trying to build a P&L that I can slice and dice as required. I get data for multiple sites and need to ability to into with a few clicks. I have the data in the below format: <tbody> Site Name Category Period 1 Period 2 Period 2 Period 3 Delta Drink Sales 5 10 15 20...
5. ### cosine power

Hi, I'm trying to find out how to write the excel formula for cosine to power of -1 using the following as the calculation: i = cos^-1(.4529) Appreciate any help you can provide. Cheers, Kit

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back