how can i set one cell is this the other is that (ex: D2=10 then D

D

Dar

how can set in excel one cell equal to this then the other cell must equal that
like cell D2 value is 10 then cell D5 value is 6
 
S

Stefi

Enter formula in D5:
=IF(D2=10,6,"what if not 10?")

Regards,
Stefi

„Dar†ezt írta:
 

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

I am stumped. Help with Formula... 5
Excel Need Countifs Formula Help 0
conditional formula keeps changing 2
reference to an external file 6
Help with this formula 3
Finding Text within an Array 2
vlookup useful? 2
SOS! how do I do multiple-value lookup in Excel 2007? 1

Top