Hi,
I'm hoping to get help with a formula. I'm not sure if it is possible but seems like it should be.
Basically I'm working out commission so I have a cell set at for example ( =SUM(10*C9) ) But I want the cell to read 0 if another cell ( F9 ) is a negative value or <0.
Is this possible? If so how would I type this?
Thank for your help.
I'm hoping to get help with a formula. I'm not sure if it is possible but seems like it should be.
Basically I'm working out commission so I have a cell set at for example ( =SUM(10*C9) ) But I want the cell to read 0 if another cell ( F9 ) is a negative value or <0.
Is this possible? If so how would I type this?
Thank for your help.