Hi-

How can I combine 2 different If statements? If c2 is a sell i want the inverse calc (-).

=IF(C2="sell",-(L2/E2-1))
=IF(C2="buy",L2/E2-1)
Thanks