Array Function & EDATE
Hi all,
I'm trying to use an array function for EDATE. My current formula is as follows: EDATE($C$13:$D$13,$C$15:$D$15) Where the values in row 13 are dates, and the values in row 15 are months. It's part of a larger formula. When I evaluate this entire formula in the formula bar using F9, it returns {#VALUE!, #VALUE!}. However, if I evaluate each of the sections individually first, namely "$C$13:$D$13" and "$C$15:$D$15", then evaluate the entire EDATE part, it returns the correct results in numbers. Even when I out that entire EDATE section and group it with a SUM function, it still returns #VALUE! I've done the ctrl+Shift+enter, so its not that. Can someone please help? Thanks Harimau |
Array Function & EDATE
Can't do much for you as you didn't show us your formula
Tyro "Harimau" wrote in message ... Hi all, I'm trying to use an array function for EDATE. My current formula is as follows: EDATE($C$13:$D$13,$C$15:$D$15) Where the values in row 13 are dates, and the values in row 15 are months. It's part of a larger formula. When I evaluate this entire formula in the formula bar using F9, it returns {#VALUE!, #VALUE!}. However, if I evaluate each of the sections individually first, namely "$C$13:$D$13" and "$C$15:$D$15", then evaluate the entire EDATE part, it returns the correct results in numbers. Even when I out that entire EDATE section and group it with a SUM function, it still returns #VALUE! I've done the ctrl+Shift+enter, so its not that. Can someone please help? Thanks Harimau |
Array Function & EDATE
I don't think EDATE will return an array.
-- Biff Microsoft Excel MVP "Harimau" wrote in message ... Hi all, I'm trying to use an array function for EDATE. My current formula is as follows: EDATE($C$13:$D$13,$C$15:$D$15) Where the values in row 13 are dates, and the values in row 15 are months. It's part of a larger formula. When I evaluate this entire formula in the formula bar using F9, it returns {#VALUE!, #VALUE!}. However, if I evaluate each of the sections individually first, namely "$C$13:$D$13" and "$C$15:$D$15", then evaluate the entire EDATE part, it returns the correct results in numbers. Even when I out that entire EDATE section and group it with a SUM function, it still returns #VALUE! I've done the ctrl+Shift+enter, so its not that. Can someone please help? Thanks Harimau |
Array Function & EDATE
On Sun, 13 Apr 2008 17:39:00 -0700, Harimau
wrote: Hi all, I'm trying to use an array function for EDATE. My current formula is as follows: EDATE($C$13:$D$13,$C$15:$D$15) Where the values in row 13 are dates, and the values in row 15 are months. It's part of a larger formula. When I evaluate this entire formula in the formula bar using F9, it returns {#VALUE!, #VALUE!}. However, if I evaluate each of the sections individually first, namely "$C$13:$D$13" and "$C$15:$D$15", then evaluate the entire EDATE part, it returns the correct results in numbers. Even when I out that entire EDATE section and group it with a SUM function, it still returns #VALUE! I've done the ctrl+Shift+enter, so its not that. Can someone please help? Thanks Harimau Whether or not a function can return arrays or handle array inputs depends on the function, and is not well documented by Excel. --ron |
All times are GMT +1. The time now is 09:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com