identify if a CalculatedField is positive or negative on VBA
 

I want to check if a calculatedfield in a pivot table is positive or negative
,for me execute a macro.
example:
result = brought * sold --is the formula for this example.
if result < 0 then
do X
elseif result 0 then
do Y
else
do Z
end if