Array Formula
I am not able to use a formatted cell within an array formula. The array
formula is set up to average the number of days it is taking to get a product from a third party vendor and one range used in the formula is formatted and the array formula does not like the formatted cell. Any thoughts on how i can get around the formatted cell / format the cell where the array formula will accept the formatted cell? Thanks, Michael |
Array Formula
You need to provide detail. Paste your formula and your sample data which is
causing the issue. Tell us what are the current errors you are getting and the expected results. p/s: Formulas, whether normal or array, work on underlying values in the precedent cells. The format applied to these precedents affect only how these values display/appear on screen, not how they are evaluated by formulas using them. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Michael" wrote: I am not able to use a formatted cell within an array formula. The array formula is set up to average the number of days it is taking to get a product from a third party vendor and one range used in the formula is formatted and the array formula does not like the formatted cell. Any thoughts on how i can get around the formatted cell / format the cell where the array formula will accept the formatted cell? Thanks, Michael |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com