Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested IF | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If help | Excel Worksheet Functions | |||
using nested OR | Excel Worksheet Functions | |||
Nested If with And | Excel Worksheet Functions |