Hello there:
I have a psychotically long "AND" formula in an "IF" formula that I would LOVE to shorten up. It's analyzing 10 cells and it's doing this on 1,800 rows so it's really killing my processing time lol
Here's what "AND" part is now: = IF ( AND (A1 = "VALUE", A2 = "VALUE", etc)
I tried shortening it to = IF ( A1:A10="VALUE") but it errored out on me.
Am I stuck by the limitations of the "AND" formula on this one or is there a shortcut?
As always, the help is much appreciated
Cheers
KD
I have a psychotically long "AND" formula in an "IF" formula that I would LOVE to shorten up. It's analyzing 10 cells and it's doing this on 1,800 rows so it's really killing my processing time lol
Here's what "AND" part is now: = IF ( AND (A1 = "VALUE", A2 = "VALUE", etc)
I tried shortening it to = IF ( A1:A10="VALUE") but it errored out on me.
Am I stuck by the limitations of the "AND" formula on this one or is there a shortcut?
As always, the help is much appreciated
Cheers
KD