| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I .........
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
Thanks, it works great.......... -- miltont ------------------------------------------------------------------------ miltont's Profile: http://www.excelforum.com/member.php...o&userid=25345 View this thread: http://www.excelforum.com/showthread...hreadid=388253 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
