Prev: If Statement Nesting?
Next: Brugervenlig udfyldning
From: murkaboris on 30 Mar 2010 14:38
Hello:

I need a formula that can look at column "A" and calculate the number of
days from today --- could be either before today or in the future and if it
is equaled to or less than 90 return "Y" otherwise "N"....

I keep getting "VALUE!" errors.
Please help.

Thank you.
Monika
From: Mike H on 30 Mar 2010 14:43
Hi,

Try this

=IF(ABS(TODAY()-A1)<=90,"Y","N")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"murkaboris" wrote:

> Hello:
>
> I need a formula that can look at column "A" and calculate the number of
> days from today --- could be either before today or in the future and if it
> is equaled to or less than 90 return "Y" otherwise "N"....
>
> I keep getting "VALUE!" errors.
> Please help.
>
> Thank you.
> Monika
From: murkaboris on 30 Mar 2010 14:50
Hi Mike:

thx for the quick response. It didn't work. When I enter the formula the
pop-up shows up saying "The formula you typed contains an error" and it
highlights the "Y" in the formula....

any ideas?
Thanks
Monika

"Mike H" wrote:

> Hi,
>
> Try this
>
> =IF(ABS(TODAY()-A1)<=90,"Y","N")
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "murkaboris" wrote:
>
> > Hello:
> >
> > I need a formula that can look at column "A" and calculate the number of
> > days from today --- could be either before today or in the future and if it
> > is equaled to or less than 90 return "Y" otherwise "N"....
> >
> > I keep getting "VALUE!" errors.
> > Please help.
> >
> > Thank you.
> > Monika
From: Mike H on 30 Mar 2010 15:08
Hmm,

Is that my formula copied and pasted from the post or one you typed?

My fomula is correct for my region, copy and paste it into a cell.

What is the delimiter in your region. My area uses a , does yours use a semi
colon ;

If so change the 2 commas to semi colons
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"murkaboris" wrote:

> Hi Mike:
>
> thx for the quick response. It didn't work. When I enter the formula the
> pop-up shows up saying "The formula you typed contains an error" and it
> highlights the "Y" in the formula....
>
> any ideas?
> Thanks
> Monika
>
> "Mike H" wrote:
>
> > Hi,
> >
> > Try this
> >
> > =IF(ABS(TODAY()-A1)<=90,"Y","N")
> > --
> > Mike
> >
> > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > introduces the fewest assumptions while still sufficiently answering the
> > question.
> >
> >
> > "murkaboris" wrote:
> >
> > > Hello:
> > >
> > > I need a formula that can look at column "A" and calculate the number of
> > > days from today --- could be either before today or in the future and if it
> > > is equaled to or less than 90 return "Y" otherwise "N"....
> > >
> > > I keep getting "VALUE!" errors.
> > > Please help.
> > >
> > > Thank you.
> > > Monika
From: murkaboris on 30 Mar 2010 15:26
Hi Mike:

Not sure what it was, but the copy paste fixed it.
Thanks for your help!

Monika

"Mike H" wrote:

> Hmm,
>
> Is that my formula copied and pasted from the post or one you typed?
>
> My fomula is correct for my region, copy and paste it into a cell.
>
> What is the delimiter in your region. My area uses a , does yours use a semi
> colon ;
>
> If so change the 2 commas to semi colons
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "murkaboris" wrote:
>
> > Hi Mike:
> >
> > thx for the quick response. It didn't work. When I enter the formula the
> > pop-up shows up saying "The formula you typed contains an error" and it
> > highlights the "Y" in the formula....
> >
> > any ideas?
> > Thanks
> > Monika
> >
> > "Mike H" wrote:
> >
> > > Hi,
> > >
> > > Try this
> > >
> > > =IF(ABS(TODAY()-A1)<=90,"Y","N")
> > > --
> > > Mike
> > >
> > > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > > introduces the fewest assumptions while still sufficiently answering the
> > > question.
> > >
> > >
> > > "murkaboris" wrote:
> > >
> > > > Hello:
> > > >
> > > > I need a formula that can look at column "A" and calculate the number of
> > > > days from today --- could be either before today or in the future and if it
> > > > is equaled to or less than 90 return "Y" otherwise "N"....
> > > >
> > > > I keep getting "VALUE!" errors.
> > > > Please help.
> > > >
> > > > Thank you.
> > > > Monika
 | 
Pages: 1
Prev: If Statement Nesting?
Next: Brugervenlig udfyldning