value error

[Guest]

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

 

[Gary Brown]

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, i
you did want it as an array formula then enter it by holding down Ctr
and Shift and then press enter, or did you mean something else

 

[Guest]

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