In excel I am trying to write a formula that determines the input into a cell  (W2) based on values in other cells.

I have started with a simple formula based on an IF true/false 

=IF(T2=0,”Q10″,”N”)

This handles one aspect of what I am trying to do but not all.

In my spreadsheet I want other cells to also influence the same W2 cell.  Speciffically cells U2 and V2.  This means that there are 3 cells ( T2, U2 and V2) that can influence the final data in W2.

Basically this is what I am trying to achieve:

if T2=0 it should input into W2 the text Q10

if U2 = elimination it should input into W2 the text E

if V2 = scratched it should input into W2 the text S

I am not even sure it is possible to write a formula for this as I am a newbie to excel but hopefully it is and someone with experience can guide me.  Here is a snapshot of the part of my spreadsheet.

​In excel I am trying to write a formula that determines the input into a cell  (W2) based on values in other cells.I have started with a simple formula based on an IF true/false =IF(T2=0,”Q10″,”N”)This handles one aspect of what I am trying to do but not all.In my spreadsheet I want other cells to also influence the same W2 cell.  Speciffically cells U2 and V2.  This means that there are 3 cells ( T2, U2 and V2) that can influence the final data in W2.Basically this is what I am trying to achieve:if T2=0 it should input into W2 the text Q10if U2 = elimination it should input into W2 the text Eif V2 = scratched it should input into W2 the text SI am not even sure it is possible to write a formula for this as I am a newbie to excel but hopefully it is and someone with experience can guide me.  Here is a snapshot of the part of my spreadsheet.    Read More

​