Formula with IF, can't get rid of #VALUE!, works for positive number not negative number.

=IF($D6<0,0,($D3*$H6/$I6))

Formula is working for all lines that have a positive figure in cell D3 but if there is a negative number in D3 such as 25.580-
then it returns #VALUE!

Thanks, I thought that might be the issue but still didn't know how to fix it. That worked!

25.580- is probably not seen by Excel as a number. You can check by entering into an empty cell =ISNUMBER(D6) and it will give a true or false
So if that is how the data is being imported
=IF(RIGHT(D6,1)="-", 0, ($D3*$H6/$I6))
might work

If this data is imported from text in some way (imported from text file or using the text to columns command), there is an option in the text import wizard (advanced options on the 3rd step) for "trailing minus for negative numbers" that will permit Excel to automatically recognize this scenario and capture the negative numbers correctly.