Forum Discussion
Solved
Treat a row as an array inside an array formulation
Hello there, Running Excel 365. Attaching a sample document for better understanding. I am trying to compute the final price of a product on each year of its project. The final price is based...
- Solved myself this issue. Did not remember that AND function does not return an array of TRUE/FALSE values. Simply using, for instance, IF( ( )*( ) ) for returning an array while using multiple conditions.
Solved myself this issue. Did not remember that AND function does not return an array of TRUE/FALSE values. Simply using, for instance, IF( ( )*( ) ) for returning an array while using multiple conditions.