formula not working "false".

[Blackwell]

Hello, I am trying to work on an accumulative formula which works ok when cell L7 have a value. but when 7 is "0", it puts in the accumulative amendments in the cell L7.
=IF(L7<0,0)=IF(L38<L39,L38*0.2,L39*0.2)-C10-D10-E10-F10-G10-H10-I10-J10-K10
Sorry tried to put this in spreadsheet but it is protected

439​

439​

439​

439​

439​

439​

1767​

628​

628​

FALSE​

1257​

628​

 

[Fluff]

How about

=IF(L7>0,IF(L38<L39,L38*0.2,L39*0.2)-C10-D10-E10-F10-G10-H10-I10-J10-K10,0)

 

[Blackwell]

Thank you again, Fluff, it works fine, thanks

 

[Fluff]

Glad to help & thanks for the feedback.