Forum Discussion
Problem with a Excel formula
Hi Steven,
Sorry, missed this your reply. I tried to play with the file you send a week or so ago and was not able to reproduce the error. But that was no data in row 249.
Could you please send me the file where you see the error?
Hello Again. Ive attached the sheet. wot ive done is and your formula to the cells in row 317. Ive added the a new set of draw results in to row 249. If you look at cells K317, R317 etc you'll see #VALUE
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
- Hi service. Tried all you said and looked at the file you attached but still won't work.
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
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.
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.
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.
Hi Sorry about that. i had to delete some of the none essential page and deleted the wrong one. Ill try again. Please try this one.
Hi Steven,
Unfortunately in the file you attached i don't see the formulas (only #REF) since 'General Lotto Info' tab is removed. Could you please send full file to check?
If you care about the confidentiality send the link where i can download it with in-private message.