Re: Complicated Formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanx, i realised that because excel said there was an error in the formula
so I just made it all go onto one line for now.

I added a few duff ones and it worked ok, will see roughly how many cases I
need when I get back to work on tuesday (not sure how many divisions there
are, can think of about 10 but will run a report on tuesday to make sure) and
add those in to see how it works. I guess excel shouldn't have a limit but
it might just take a while to work through them. I'll see how it goes and
let you know.

Thanks mate now I'm off down to the pub! I'd buy you a pint in return but
Im guessing you don't live next door!

Cheers again,

Andy

"Ian" wrote:

> I assumed there world be more than 2 cases. I don't know if there's a limit
> to the number of cases. Excel help does not specify. If there are a lot of
> cases, it may be worth creating the required number (just the Case "xyz"
> bit) with any old values, just to test it before you go to the trouble of
> working out the formulae.
>
> BTW, the lines have been wrapped, there was only one formula line for each
> case. If you want to keep the lines short (so they stay on screen) you can
> enter an underscore "_" at the end of one part of the formula and continue
> on the next line.
>
> --
> Ian
> --

.

Relevant Pages

  • Re: Removing Spaces
    ... Why bother with that when this is one way to import a list of all mp3 files into an excel worksheet. ... Ian & Sylvia - Early Morning Rain.mp3 ... ARTIST\ARTIST - SONG ...
    (microsoft.public.excel.misc)
  • Re: Really tough Stored Procedure Debug Problem.
    ... "Ian" wrote in message ... > Hi Steve. ... >> Excel import, but it could also bee that one of your Excel sheets ... >>>NOT WORKING CODE ...
    (microsoft.public.sqlserver.programming)
  • Re: Really tough Stored Procedure Debug Problem.
    ... ANSI_NULLS need to be set outside, when you create the proc. ... > "Ian" wrote in message ... >>> Excel import, but it could also bee that one of your Excel sheets ... >>> makes more sense than creating similar but different, working code and ...
    (microsoft.public.sqlserver.programming)
  • Re: Adding durations/phone bill
    ... Have been off-line for a while - looks like Ian has sorted it out. ... Basically, the data is text (in an Excel file), so it has to be ... High light a cell, click sigma, select range of cells, enter. ...
    (microsoft.public.excel)
  • Re: Printing wrapped cell not WYSIWYG
    ... Ian S wrote: ... The text to the left of the cell is hidden. ... > problem only occurred for files transfered from Excel for Windows. ... as said, this is just a clue, let us know if it points you out... ...
    (microsoft.public.mac.office.excel)