cos

  1. H

    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. K

    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. H

    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. A

    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. K

    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

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top