Hello,
I really need help with one thing in excel 2016
Ill try to describe my problem:
I have big data file with columns from A to W
I am categorizing them and want to create a "derivative" column (if this is the correct term).
For example
If cell from column A1 contains value 1, and cell from H1 contains value "5 and random text", and cell k1 contains "random text" THEN put name on cell X1=category 1. (and i wish to create ~3 such categorys with different if's)
Does this kind of function IF exists in excel?
Have I described my problem clear enough?
I really need help with one thing in excel 2016
Ill try to describe my problem:
I have big data file with columns from A to W
I am categorizing them and want to create a "derivative" column (if this is the correct term).
For example
If cell from column A1 contains value 1, and cell from H1 contains value "5 and random text", and cell k1 contains "random text" THEN put name on cell X1=category 1. (and i wish to create ~3 such categorys with different if's)
Does this kind of function IF exists in excel?
Have I described my problem clear enough?