formula problem

hi

Quote:

=IIf([text28]=0,[qtyreqd]-[qtyrecd],[qtyreqd]-[qtyrecd]+[text28])

the formula is not giving me the negative or positive results I should get

for example



qtyreqd 53

qtyrecd 53

text28 1 ( rejected qty)



should give me an answer of -1

but I get 1

if I increase the qtyrecd to 60 I get -6 yet I want 6



if I decrease the qtyrecd to 10 I get 44



I think it is to do with the {text28] as the operator will enter a positive number this maybe should show a negative number

can this positive been turned into a negative number within the formula

any help appreciated



steve

formula problem