l the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* 'DanJ' via MS EXCEL AND VBA MACROS >
> *To:* excel-...@googlegroups.
CROS
>To: excel-macros@googlegroups.com
>Cc: schreiner_p...@att.net
>Sent: Wednesday, September 10, 2014 10:38 PM
>Subject: Re: $$Excel-Macros$$ Convert IF formula to VBA
>
>
>
>Hi Paul,
>
>
>Sorry, if my question is vague.
>
>
>I would like VBA to perfor
times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> -
>>
>>*From:* 'DanJ' via MS EXCEL AND VBA MACROS > >
>> *To:* excel-...@googlegroups.com
>> *Sent:* Wednesday, Sept
gt; can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* 'DanJ' via MS EXCEL AND VBA MACROS >
> *To:* excel-...@googlegroups.com
> *
gt; *To:* excel-...@googlegroups.com
> *Sent:* Wednesday, September 10, 2014 2:35 AM
> *Subject:* $$Excel-Macros$$ Convert IF formula to VBA
>
> Dear Everyone,
>
> I want to categorize age of receivables based on the number of days due
> using the formula below. The formula
ia MS EXCEL AND VBA MACROS
>To: excel-macros@googlegroups.com
>Sent: Wednesday, September 10, 2014 2:35 AM
>Subject: $$Excel-Macros$$ Convert IF formula to VBA
>
>
>
>Dear Everyone,
>
>
>I want to categorize age of receivables based on the number of days due using
&
Hi
You can use fill down method to copy formula to succeeding rows..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Sep 10, 2014 at 12:05 PM, 'DanJ' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Dear Everyone,
>
> I want to c
Dear Everyone,
I want to categorize age of receivables based on the number of days due
using the formula below. The formula is in cell B2.
=IF(A2>=180,"181 days up",IF(A2>90,"91-180 days",IF(A2>60,"61-90
days",IF(A2>30,"31 to 60 days",IF(A2>0,"1 to 30
days",IF(A2<=0,"Current"))
How do I
