Use of IF

[nik7]

Hi in the attached document i need a formula which appears in the F cells the number 1 or 2 according to the value of the D cells. For example if in the CELL D3 the Value Accepted is chosen i need F3 to present value 1 and if The value not accepted is chosen i need to appear the value 2.

How can i do that?F-019 Data.xlsx

Thank you.

[Fotis1991]

Hi__Καλημέρα!!

Hoping that i understand well your query, try in E16 and copy down.

Please Login or Register  to view this content.

[Kaper]

Or other way round - I'd check for both Accepted and Not Accepted.
try in F16:

Please Login or Register  to view this content.

and copy down

[nik7]

Ευχαριστώ πολύ Φώτη

[Fotis1991]

You are welcome and thanks for the feedback--Νά'σαι καλά Φίλε μου..

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.