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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can i set one cell is this the other is that (ex: D2=10 then D (https://www.excelbanter.com/excel-discussion-misc-queries/206349-how-can-i-set-one-cell-other-ex-d2%3D10-then-d.html)

Dar

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

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

Stefi

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

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

Regards,
Stefi

€žDar€ ezt Ã*rta:

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

All times are GMT +1. The time now is 09:06 AM.