Nested IFs
Please, I need a for me complex formula to do the following:
1. if line 1 = line 2 in column A, then "No." in column C, if not then
" ",
2. if line 1 = line 2 in column B, then "Date" in column D, if not
then " ",
3. if line 1 = line 2 in column C, then "Amount" in column E, if not
then " ",
4. if line 1 = line 2 in column A and if line 1 = line 2 in column B
and if line 1 = line 2 in column C, then "HIT" in column F, if not
then " "
Thanks for your effort.
Alvaro
|