Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe an array is needed?
Morning,
I have eight cells that return a text message if certain conditions are met. Those eight cells have a named range, Range_1. Currently the formula I have tests just one cell for that string; =IF(G20=msg, "XXX", ""). I would like to enhance this formula to test if any of the cells in Range_1 result in that string (a named range msg), and if so display a more detailed message now €œXXX€, elsewhere. I am trying to work through an array, currently unsuccessfully. Sincerely, Arturo |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe an array is needed?
=IF(OR(Range_1=msg),"XXX","") array-entered.
Bob Umlas Excel MVP I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks on Aug 24, Sept 28, Oct 12. If interested, go to http://www.iil.com, click on the yellow/orange "Try a free webinar" link on the left side, click the Microsoft Excel Tips & Tricks link, follow instructions to register. You can also order my book on tips & tricks by visiting the site http://www.iil.com/iil/excelmagic Thanks. Bob Umlas "Arturo" wrote in message ... Morning, I have eight cells that return a text message if certain conditions are met. Those eight cells have a named range, Range_1. Currently the formula I have tests just one cell for that string; =IF(G20=msg, "XXX", ""). I would like to enhance this formula to test if any of the cells in Range_1 result in that string (a named range msg), and if so display a more detailed message now "XXX", elsewhere. I am trying to work through an array, currently unsuccessfully. Sincerely, Arturo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
defintion of array function | Excel Discussion (Misc queries) | |||
How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
Array formula expertise needed | Excel Worksheet Functions | |||
Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |