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
I would appreciate if someone could help.
Regards Hennie_vW