8th March 2018, 07:22 PM
|
Member
|
|
Join Date: Aug 2007
Posts: 446
|
|
Excel formula help
Lets say on my sheet I am recording results in column A which dont include commission. If I want the result after commission to be calculated into column B next to the result, What would be the formula to make it calculate a 5% commission on a positive result but leave a loss value as it is?
I'm guessing it will be some king of IF statement saying if positive multiply by 0.95, but IF negative value do not multiply and simply populate value with same figure.
ie
ColumnA/columnB
100/95
-100/-100
|