I use this formula to figure margin =(Retail/Cost)/ABS(Retail). The issue is my spreadsheet has current cost and new cost. There is not always a cost increase so I would like to choose column B, unless if blank choose column A. As an addendum, Cost can fluctuate up or down.
Screenshot 2023-08-16 110716.jpg
Bookmarks