need help revising
 

=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

need help revising
 

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

need help revising
 

Cool, thanks for the info. Data entered only at C6 and C7

C6 100 -100 -100
C7 4 1 5
C8 25 -100 -20
C9 22 22 22
C10 8 -100 -110

I can get the first two columns just fine but the 3rd one is tricky to
me.

need help revising
 

day wrote:
Cool, thanks for the info. Data entered only at C6 and C7

C6 100 -100 -100
C7 4 1 5
C8 25 -100 -20
C9 22 22 22
C10 8 -100 -110

I can get the first two columns just fine but the 3rd one is tricky to
me.

Sorry, I'm just too daft to understand what you need without you
specifying better than this... Your first post still looks like two
separate statements... Where is this formula going to be, in C10??? But
you only enter data in C6 and C7, what about C8 and C9? If no one else
solves this perhaps you can walk me through the logical requirements?

/impslayer, as daft as they come

need help revising
 

c6 is the invoice
c7 is the actual occurence
c8 (the actual cost of a job) = c6/c7
and c9 is a constant number (a rate)

What I wanted in C10 was the amount of gain or loss. In the 3rd
column, we gave $100 credit of work to 5 people, considering that it
cost $22 everytime, I wanted to calculate it so that we lost $110
instead. I couldn't figure it out... too many parameters.

thanks... and you're not daft... I just didn't explain myself