Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Microsoft Excel 2010 weird formulas

  • 11-10-2011 6:09pm
    #1
    BFassassin
    Registered Users, Registered Users 2 Posts: 2,149 ✭✭✭


    Im a bit stumped with this one. For some reason when i input a formula it shows the info as columns rather than cells. It would be much easier if it was in cells when it comes to editing the formulas.

    This is an example of on of the formulas
    =IF([@Column17]="","",([@Column17]))
    Column 17 should be X18 really.

    Would appreciate if anyone has an idea.


Comments

  • #2
    homer911
    Registered Users, Registered Users 2 Posts: 5,163 ✭✭✭homer911


    Is this formula in a table of data that you have formatted, or applied a filter to, before you added the formula?

    When I use "Format as Table" in Office 2007, I can create formulas like this:

    =Table1#This Row],[A*Table1#This Row],[C


  • #3
    BFassassin
    Registered Users, Registered Users 2 Posts: 2,149 ✭✭✭BFassassin


    Yeah they are in a table actually. Do you know if there is a way of switching it back?

    Thanks btw


  • #4
    homer911
    Registered Users, Registered Users 2 Posts: 5,163 ✭✭✭homer911


    Select the table, then click on Table Tools > Design. then under "Tools" select "Convert to Range"


  • #5
    BFassassin
    Registered Users, Registered Users 2 Posts: 2,149 ✭✭✭BFassassin


    Thanks homer911. Worked perfectly.


  • #6
    kellogskelly
    Registered Users, Registered Users 2 Posts: 27 ✭kellogskelly


    Hi, I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the problem is?


  • Advertisement
  • #7
    homer911
    Registered Users, Registered Users 2 Posts: 5,163 ✭✭✭homer911


    kellogskelly wrote: »
    Hi, I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the problem is?

    Sounds like you haven't defined or formatted your ranges completely - If you could post a sample workbook, I'm sure someone could advise


  • #8
    Taltos
    Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭Taltos


    kellogskelly wrote: »
    Hi, I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the problem is?

    Yup - I am hating the new excel too - old one was alot more intuitive with graphs.

    When this happens to me I do the following.

    1. Select chart.
    2. Right click on chart (you might be able to go straight here.
    3. Choose "Select Data"
    4. X axis: Select "Edit" under Horizontal (Category) Axis Label.
    I normally also have to select the Legend entries as well on the left here - just be careful when selecting them.

    Sometimes just hitting the "Switch Row/Column" can fix things - but more often than not I have do follow steps 1 to 4 above.


Advertisement