Conditional cell calculating logic

[Hennie_vW]

Good day, I am using an Excel spreadsheet to do various calculations (rows and columns). My challenge is that when there are negative numbers, they all have to be registered as 0 (zero). I never used the IF function in Excel before, so I tried it, but no luck. I may not understand it correctly. My initial entry/attempt in order to try and structure the conditional formula, was: =IF(C16<0,0,$E$6*C16). What I had wanted was that if the value in C16<0, D16 must=zero, otherwise if C16's value is calculated as being positive (>0), D16's value is to be calculated as being =$E$6*C16.

I would appreciate if someone could help.
Regards Hennie_vW

 

[arthurbr]

There is nothing wrong with your formula if you enter it in D16

 

[Hennie_vW]

Thanks Arthurbr, at least it is encouraging. Yes it was entered in D16. I will try again and see if I could get the calculations to right.
Today time is limited, but I will follow up.
Regards Hennie_vW