Forum Discussion
OmarC85
Aug 11, 2023Copper Contributor
Excel Novice - Simple Formula I cannot get right
Good afternoon All,
Pretty hopeless person using Excel here.
I have a question regarding a formula regarding negative numbers.
We operate a profit share spreadsheet between us and what I am wanting to do is, if we make a loss on a product we sell, I want to divide a negative value by 2. Or if the number is positive, just show the number. This is on the back of subtracting two values, the cost price - the selling price.
In simple terms we have a cost price in one cell say A1, and our Selling Price in B1.
If it costs us £50.00 to make and we sell at £70.00 then the profit made is £20.00. The number is >0 so just display the number.
If it costs is £50.00 and we make a loss and sell at £30.00, then this is -£30.00. I want to divide this negative value by two so we can remove this amount from the sellers commission.
Is there such formula I can use which says If A1-B1 is negative, divide the number by 2, if it isn't, just show the number?
Hope this males sense and any help would be appreciated.
- Riny_van_EekelenPlatinum Contributor
- OmarC85Copper ContributorSo simple when you now think about it. I am very grateful thank you.