Cell entry determines if a figure is negative

[I heart Excel]

Hello

I have a form that is filled out by my colleagues. One of the fields is a drop down. The user selects 'Request' or 'Cancellation' in cell F10.

At the end of the form is a total field in cell F36, what I would like to happen is when Cancellation is selected in Cell F10, F36 becomes a negative figure.

Any ideas, I have had a look online and had a play, but I can't seem to figure it out.

Thanks in advance.

 

[Expiry]

Apply this IF statement to whatever the formula is in F36. For this example I'll use =SUM(A1:A10)

=IF(F10="Cancellation",-sum(A1:A10),sum(A1:A10))

 

[I heart Excel]

Worked perfectly, thanks

Also I love your mug!!