if statemant

  • Thread starter Thread starter mikespeck
  • Start date Start date
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
 
is this what you need

(paste this funtion into A3

=IF(M1=1,M6,""

if this is not what you need, please elaborate... :
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentages breakouts for Ranking 1
Average formula works but.... 3
Excel 2007 - AVERAGEIF on rows that are non-continuous 2
Average formula only works partially..... 6
Fill Down command Question 2
IF Statement Problem 3
Sum columns dynamically 1
M1 Processors 3

Back
Top