To many arguments in formula but not sure why.

[drewszone32]

=IF(E7>0,SUM(E38+E18-E33),IF(E7,D38<0,SUM(D39+E18-E33),IF(D38>0,SUM(D38+E18-E33,0)))


The above formula seems to not want to work. It tells me to many arguments but I am not sure why.


If cell E7 is >0 sum E38+E18-E33


If cell E7 and D38 is <0 sum D39+E18-E33


If cell D38 >0 sum D38+E18-E33


Why is this not working. What am I missing?

 

[bobhc]

Good day drewszone32


try this


=IF(E7>0,SUM(E38+E18-E33,IF(E7,D38<0,SUM(D39+E18-E33,IF(D38>0,SUM(D38+E18-E33,0))))))

 

[drewszone32]

When I implement the formula into spreadsheet it comes up as false instead of number.

 

[DaveTurton]

try this:

=IF(E7>0,SUM(E38+E18-E33),IF(AND(E7<0,D38<0),SUM(D39+E18-E33),IF(D38>0,SUM(D38+E18-E33,0))))

 

[drewszone32]

The formula worked thank you

 

[drewszone32]

When I add an amount in E7 is <0 the formula works. Once I add an amount in E7 it changes to false.


Can someone tell me why

 

[DaveTurton]

Can you upload a sample?

 

[oldchippy]

Hi,


Try this one


=IF(E7>0,SUM(E38+E18-E33),IF(AND(E7<0,D38<0),SUM(D39+E18-E33),IF(D38>0,SUM(D38+E18-E33),0)))


The last zero needs to be on the outer parentheses