Forum Discussion

steven Green's avatar
steven Green
Copper Contributor
Aug 21, 2017

Problem with a Excel formula

Hi Not sure what I've done but the only thing I've changed is the number of cells/ lines in the range from: =MAX(IF('Draw Results'!C1:C2248={3,4},'Draw Results'!D1:D2248)) to =MAX(IF('Draw Results'!...
Formulas & Functions
tips and tricks
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 28, 2017

Hi Steven,

 

That's since in B249 you enter the text "12.7.17" instead of the date in your locale format. If change on date (actually number) formulas work. Please see attached.

steven Green's avatar
steven Green
Copper Contributor
Oct 01, 2017

Hi Sergei. Ive done as you have suggested but still getting the same probelm. Ive attached a PDF of a screen shot of what i get when i try to open the file to work on it. I have circled the cells that have #Value in them incase the image is not great. 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 05, 2017

    Steven,

     

    That could be something else, but i see no errors in my copy of the file. How your date is entered you may check in formula bar. If as text

    you have an error, if as date

    all works

  • steven Green's avatar
    steven Green
    Copper Contributor
    Oct 29, 2017
    Hi service. Tried all you said and looked at the file you attached but still won't work.
  • steven Green's avatar
    steven Green
    Copper Contributor
    Oct 13, 2017

    Hi Sorry it took so long to reply but my laptop has been away for repair. Will try your suggestion as sson as i can. thank you

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 02, 2017

    Hi Steven,

     

    As the date you have to enter the date in your locale format (12/07/2017 by default for UK) or simply the number 42928 (which is equivalent of that date). Or by refrence on previous date

    =B248+4

    And only after that apply format if necessary.

     

    Please see the file in my previous post.

Resources