excel

  1. E

    Excel formula problem for VAT Tax?

    I Live in South Africa so My VAT tax is 14%. SO All I need excel to do is in 1 block show 14% of a figure. PLease help So Say my figure was in A2 I need A4 to show 14% of the figure in A2
  2. P

    I'm looking for some advice on Excel - i.e. how to run off invoices using...

    ...information already provided? My work is quite a small organisation and we're all self taught. At the minute we use Excel for a number of things, the main one being used as a booking form. We have names listed down column A, with dates/trips listed along row 1. We then input OFF/IN/AM/PM into...
  3. P

    I'm looking for some advice on Excel - i.e. how to run off invoices using...

    ...information already provided? My work is quite a small organisation and we're all self taught. At the minute we use Excel for a number of things, the main one being used as a booking form. We have names listed down column A, with dates/trips listed along row 1. We then input OFF/IN/AM/PM into...
  4. P

    I'm looking for some advice on Excel - i.e. how to run off invoices using...

    ...information already provided? My work is quite a small organisation and we're all self taught. At the minute we use Excel for a number of things, the main one being used as a booking form. We have names listed down column A, with dates/trips listed along row 1. We then input OFF/IN/AM/PM into...
  5. B

    How do I get Excel to ignore 'the' when sorting titles?

    I have Microsoft Excel 2007 and I'm currently making a list of games I own on it, I want it sort alphabetically by title but when I do it just shoves every game that starts with 'the' in the T's. How do I get it so that it would sort say for instance "The Ship" with the S's instead of the T's?
  6. B

    How do I get Excel to ignore 'the' when sorting titles?

    I have Microsoft Excel 2007 and I'm currently making a list of games I own on it, I want it sort alphabetically by title but when I do it just shoves every game that starts with 'the' in the T's. How do I get it so that it would sort say for instance "The Ship" with the S's instead of the T's?
  7. B

    How do I get my PDA to scan bar codes into pocket excel while I'm scanning into...

    ...another program? I use a Dell Axim x5 with a scanner attached to scan the bar codes of books in order to find out their prices on the net. I would like to get a listing of each bar code scanned in pocket excel without having to scan each bar code twice.
  8. N

    Can anyone help me with MS Excel 2007?

    Does anyone know the fastest way to insert a whole row? The thing is I have a huge table and have to insert a row in every second row. Here's a picture: http://i70.photobucket.com/albums/i117/niuri_cigarete/lentele.png I have to do the same thing from the bottom of the table to the top of the...
  9. L

    ....please help with excel....?

    every time I type in the value 0.9 it changes to 0-jan how do I stop this from happening? The cell I'm typing it in to has no formula and doesn't seem to be set to do this. cheers
  10. M

    Microsoft Excel Percentages Formula?

    Hi, I work for a delivery service, and they want me to workout the % of what i sell from to what i don't i have been given a excel sheet with Total deliveries: 8 Total sold: 7 Total not sold: 1 Percentage: (I need the formula that goes here)
  11. S

    How to set up a trivia game in excel?

    I am trying to make a game with random facts about me and my friends but I have no idea how to program it. I know it can be done in excel but don't know how to do it. Does anyone know how? Okay fair enough How do you make it using VBA?
  12. V

    Can find a stupid 2007 excel torrent?

    All I find are these ebok bibles when searching for a excell 2007 torrent, its like excell 2007 doesnt even exist! Can someone help me?
  13. B

    How come when I do the linear regression function on Excel, it only returns one...

    ...statistic? When I do LINEST, it only returns one number. I'm supposed to get 10 statistics. How do I get those other ones?
  14. D

    i want to know that how can i view excel, word files in my nokia 5233?

    basically i want to download that software through which i can view excel, word (ms office files) in my nokia 5233 mobile
  15. C

    Need Statistics and Excel help :(?

    I need to create graphical display of data set both qualitative and quantitative on MS excel. There is like 200 in the list. but i will give u just a small sample and can u show mw how to create the charts i tried for hours and couldnt get anything. yearhandbeliefcolor 12l46 1l22 1r34 1r33
  16. J

    How to paste as text in excel?

    I want to copy data (including formulae) and paste that as text as it appears on the original spreadsheet. however every time i do it does not. how do i do this?
  17. T

    where can i fine a website that will show Microsoft Office Excel 2003?

    hi i have to learn Microsoft Office Excel 2003 I KNOW ABOUT Microsoft Office 2007 BUT MY QUESTION IS ABOUT 2003 ONLY IS THERE A WEBSITE THAT WILL SHOW ME HOW TO USE IT AND VERY BASIC TEACHING OF IT.
  18. S

    how to work if function in excel in longer Logical?

    how to work if function in excel in longer Logical i.e ( if a1="a","apple",if(a1="b", "ball",if(a1="c","cat",if(a1="d", "dog",if(a1="e","egg",if(a1=f","fan"............... so on) its logical is too long that why it is not working , how can do this process in excel .
  19. J

    need help with excel project?

    can someone please put this into clearer terms for me, its an i.t project that is super important! ------------------ The proprietors of the Golden Tiger Herbal Emporium, Jock and Agnes McGregor, are looking for a new solution to help them develop a pricing structure for their range of medicinal...
  20. S

    Number of days calculation in Excel 2007?

    What formula do i use to calculate the number of days between a date before Dec.19, 2009, divided by 365.25 and applying a floor function....
Back
Top