if statemant

M

mikespeck

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 i
cell M1 to dump the value of M6 into A3 automaticall
 
T

teelim

is this what you need

(paste this funtion into A3

=IF(M1=1,M6,""

if this is not what you need, please elaborate... :
 
Top