Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro_AND function
There is an formula Id like to add it in a macro.
=IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N") I want it to automatically fill up for the rest of row. Any suggestion? Thanks, -- Aline -- Aline |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro_AND function
Another formula (OR formula) I have: =IF(OR(E3="B", E3="C", E3="E"), "Y", "N")
It works well in the macro: ..Range("L3:L" & LastRow).Formula _ = "=IF(E3=""B"", ""Y"", IF(OR(E3=""C""," _ & "E3=""E""), ""Y"", ""N""))" Just could not figure out what to do with AND formula. Thanks, -- Aline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro_AND function | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |