IF(U4="","",IF(U4<'MDA Portfolio Summary'!H3,('MDA Portfolio Summary'!H3-MDA
Portfolio Summary'!G3)*(K4:K39),IF(U4'MDA Portfolio Summary'!J3,('MDA
Portfolio Summary'!G3-'MDA Portfolio Summary'!J3)*(K4:K39),"")))

i am trying to have the difference of H3 and G3 if it is lower or higher,
but i get a value error
not sure what is wrong
thanks anyone

The formula you have is an array formula with the bit *(K4:K39)

Did you mean this to be the sum(K4:K39), if so enter it accordingly, if
you did want it as an array formula then enter it by holding down Ctrl
and Shift and then press enter, or did you mean something else?


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=375900

Hi Gary
i meant that (K4:K39) as the sum of those cells multiplied by the result of
the difference of the other cells. i thought that by entering it this way it
would give me that result

"Gary Brown" wrote:


The formula you have is an array formula with the bit *(K4:K39)

Did you mean this to be the sum(K4:K39), if so enter it accordingly, if
you did want it as an array formula then enter it by holding down Ctrl
and Shift and then press enter, or did you mean something else?


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=375900