How do I .........

[miltont]

Hi guys, a newbie here....Is it possible for the following?

Into cell M9
If cell G6 is blank insert into cell M9..cell A6,
OR
if cell G7 is blank insert into cell M9 ...cellA7
OR
if cell G8 is blank insert into cell M9 ...cellA8

Any help appreciated


milton

[aristotle]

=IF(ISBLANK(G6),A6,IF(ISBLANK(G7),A7,IF(ISBLANK(G8),A8,"No condition met")))

"miltont" wrote:

>
> Hi guys, a newbie here....Is it possible for the following?
>
> Into cell M9
> If cell G6 is blank insert into cell M9..cell A6,
> OR
> if cell G7 is blank insert into cell M9 ...cellA7
> OR
> if cell G8 is blank insert into cell M9 ...cellA8
>
> Any help appreciated
>
>
> milton
>
>
> --
> miltont
> ------------------------------------------------------------------------
> miltont's Profile: http://www.excelforum.com/member.php...o&userid=25345
> View this thread: http://www.excelforum.com/showthread...hreadid=388253
>
>

[miltont]

Thanks, it works great..........