Excel Formula Help (IF, THEN, LESS THAN) - Techist - Tech Forum

 Techist - Tech Forum Excel Formula Help (IF, THEN, LESS THAN)
 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 04-25-2008, 09:04 PM #1 (permalink) Imperial Space Womble     Join Date: Jan 2004 Location: Australia Posts: 6,903 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 =1+(COST*15%) 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. =if((cost*15%)>100,cost*15%,100) __________________ __________________ "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
 04-26-2008, 03:42 PM #2 (permalink) Monster Techie   Join Date: May 2004 Location: /usr/root/mn/us Posts: 1,118 or you could just do this =max((cost*1.15), 100) Sorry that should be max not min above (I can't edit for some reason, otherwise I would change it) *Mod note* I edited it for you bla!! I think there is a time frame on the edits. Mak __________________ Its a frigging Laptop, not a Labtop!!!!

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post therascalking New Systems | Building and Buying 40 04-17-2008 04:44 PM Emper0r Programming 1 01-30-2008 08:38 PM Vegeeta Microsoft Windows and Software 2 01-21-2008 08:54 AM CntdwnToExtn Linux and Open Source 0 10-16-2007 11:07 AM superdave1984 Microsoft Windows and Software 0 09-26-2007 10:48 AM

#### Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

#### Automotive Communities

Our Automotive communities encompass many different makes and models. From U.S. domestics to European Saloons.

» More about our Automotive Communities

#### Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities