WHAT #VALUE! MEAN

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DERBIE - 30 Oct 2007 02:01 GMT

THEY GIVE ME A FORMULA IN THE BOOK <=TODAY()-E2/365>
EACH TIME I TYPE THE FORMULA IN PRESS ENTER I GOT THIS #VALUE! AS A RESULT.I
DID IT BEFORE IN THE SCHOOL THE RESULT WAS OK.IS THAT HAVE SOMETHING TO DO
WITH MY COMPUTER OR DO I MAKE A MISTAKE.
THANKS IN ADVANCE FOR YOUR ANSWER AND YOUR PRECIOUS HELP

Reply to this Message

OssieMac - 30 Oct 2007 02:30 GMT

Hi Derbie,

What value do you have in E2?

Your formula should be written exactly like this:-

=TODAY()-E2/365

or are you including the < and > signs like in your post?

Regards,

OssieMac

> THEY GIVE ME A FORMULA IN THE BOOK <=TODAY()-E2/365>
> EACH TIME I TYPE THE FORMULA IN PRESS ENTER I GOT THIS #VALUE! AS A RESULT.I
> DID IT BEFORE IN THE SCHOOL THE RESULT WAS OK.IS THAT HAVE SOMETHING TO DO
> WITH MY COMPUTER OR DO I MAKE A MISTAKE.
> THANKS IN ADVANCE FOR YOUR ANSWER AND YOUR PRECIOUS HELP

Reply to this Message