day skrev:

=IF(D6<0,D6,IF(D9<D8,D6-D9*D7,D6-(D9*D7)))

The above is the the current formula I have, however I need to change
it a bit to get the results I need for the different variables. Here
are my conditions:

If C6<0 and C7=1 then C6, else -(C9*C7)
if C9<C8 then C6-C9*C7, else C6-(C9*C7)

I came up with this, but it says that I have too many arguments.

=IF(AND(C6<0,C7=1),C6,-(C9*C7), IF(C9<C8,C6-C9*C7,C6-(C9*C7)))

Some Excel genius out there must be able to help me.

thanks in advance

Day

Remember IF only takes three parameters, condition and the two
branches...

In your case the nested IF is a FOURTH parameter...

Not sure about your requirements though, it seems like two unrelated
logical statements!
Could you provide more information?

/impslayer, aka Birger Johansson