Hi All,
I need a formula;
A1:M1 have months, Jan...Feb...March...etc.
A2:M2 have dollar amounts,
I need to fill A3:M3 with these dollar amounts only if it is the current month.
The remainder of the cells from A3:M3 to remain unfilled.
Thanks
Ben
Mike H - 06 Feb 2008 19:58 GMT
On the assumption you have jan etc in Row 1 formatted properly try this in A3
and drag right
Mike
> Hi All,
> I need a formula;
[quoted text clipped - 4 lines]
> Thanks
> Ben
BenT - 06 Feb 2008 21:40 GMT
Mike
I thank you very much, it drove me crazy, with your help I done did it,
Thanks, Ben
On the assumption you have jan etc in Row 1 formatted properly try this in A3
and drag right
Mike
"BenT" wrote:
> Hi All,
> I need a formula;
> A1:M1 have months, Jan...Feb...March...etc.
> A2:M2 have dollar amounts,
> I need to fill A3:M3 with these dollar amounts only if it is the current month.
> The remainder of the cells from A3:M3 to remain unfilled.
> Thanks
> Ben
Mike H - 06 Feb 2008 19:58 GMT
The formula may be useful
=IF(MONTH(TODAY())=MONTH(A1),A2,"")
> Hi All,
> I need a formula;
[quoted text clipped - 4 lines]
> Thanks
> Ben