Thread: Nested IFs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alvaro Alvaro is offline
external usenet poster
 
Posts: 4
Default 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