| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statemant
I'm looking for something like this. If M1.value = 1 then I need A3. value = M6.value Please help. I need this automated so whenever anyone enters a 1 in cell M1 to dump the value of M6 into A3 automatically -- mikespeck ------------------------------------------------------------------------ mikespeck's Profile: http://www.excelforum.com/member.php...o&userid=34946 View this thread: http://www.excelforum.com/showthread...hreadid=568660 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statemant
is this what you need? (paste this funtion into A3) =IF(M1=1,M6,"") if this is not what you need, please elaborate... :) -- teelim ------------------------------------------------------------------------ teelim's Profile: http://www.excelforum.com/member.php...o&userid=36856 View this thread: http://www.excelforum.com/showthread...hreadid=568660 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
