I must be getting rusty on my Excel formulas as I worked this out a few years back.
I have a spreadsheet to help my work out my computer system pricing.
Right now, I have COST + MARGIN = SELL PRICE
Right now, I need help on my MARGIN formula. When I sell a computer system, I want to be able to make 15% of COST PRICE, but no less than$100
15% of COST PRICE is easy
However the hard part is IF 1+(COST*15%) = Less Than $100, I do want the value = $100
I am just a little lost on how i put that formula into Excel.
BTW, I do know that LESS THAN is >
At the end of the day, I want some thing that my co-worker can use without him complain then he has to manually have to work things out.
"I FEEL SO GOOD I FEEL SO NUMB, YEAH!!!" -- Rob Zombie
Main Rig - AMD FX-8350x8 4.0Ghz CPU, 4x 8Gb (32Gb) DDR3 Ram, Gigabyte GA-970A-D3, GeForce GT 970 4Gb, 1x 256Gb SSD\8Tb (3+2+2+1) SATA HDD, DVDRW, SB X-Fi, Win 10 (64-bit)
Asus N61JV-JX231V - Intel Core i5 3437u (1.9 - 2.4 GHz), 12GB, 640GB, 16" Display, nVidia 325M 1Gb, DVD-RW, Win 10 (64-bit)
Mobile Phone : Samsung Galaxy 5 Note SM-N920IConsole : Play Station 4