View Single Post
  #1  
Old 8th March 2018, 07:22 PM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 446
Default 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
Reply With Quote