Multiple formulas
I am trying to add a multiple function but it isn't working. Basically this
is what I am looking for:
If someone hasn't achieved their sales goals in their first quarter of
sales, enter a negative $ figure
In theie next quarter if they have achieved their goal by $1000.00, take the
$1000 and take away the first quarters negative number.
For example (Quarter 1 $-479), (Quarter 2 +$1000) I want the final figure
to show a positive of $523 so commissions can be paid.
Can someone help with this????
Thanks
|