microsoft excel 2010

  1. T

    Creating a conditional format useing an IF statement

    ok i i am working on my school final exam and i need to make a conditional format useing an if statement that allows the cells that need information to be typed into to be highlighted but i want to keep it clean so i dont want a half of page of highlighted cells. Is there an IF statement that...
  2. L

    Using If statments and Data Validation

    I am trying to create a formula consisting of if statements based on a data validation box. The formula im trying is =IF(a1="Medium",i9*0.03,=if(a1="High",i9*0.7,=if(a1="Low",i9*0.01,0))) A1 is in a table with a dropdown box to limit to High,Medium,and Low.im also adding similar if statments...
  3. T

    Useing an If Statement with the data validation function (drop down list)

    ok i am doing a final exam spreed sheet for my school and i need to use an If statement with the data validation function (drop down list) here's what i got so far =IF(L2="poor",1*L15,""=IF(L2="Normal",L15*2,=if(L2="Awsome", L15*3,0))) where as "poor", "Normal", "Awsome" are the option in...
  4. L

    Office 2010 - Stacked Column Totals Legend Issue

    I needed to add data labels containing the totals for a stacked column bar graph. I used both the line chart strategy and the x-y chart strategy. Both gave me totals. The problem now is that my legend reveals a third series which I do not want to show up. I do, however, want the other 2 series...

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
Back
Top