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

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