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

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Closed Thread
Thread Tools Display Modes
Old 04-25-2008, 09:04 PM   #1 (permalink)
Imperial Space Womble
Harper's Avatar
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

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.



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
Harper is offline  
Old 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.


Its a frigging Laptop, not a Labtop!!!!
bla!! is offline  
Closed Thread

Thread Tools
Display Modes

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
upgrade questions? rampage formula? Q6600? therascalking New Systems | Building and Buying 40 04-17-2008 04:44 PM
Amortization table in Excel Emper0r Programming 1 01-30-2008 08:38 PM
Curiosity with Excel 2000 Vegeeta Microsoft Windows and Software 2 01-21-2008 08:54 AM
Calc to Excel & vice verca cell protection hash CntdwnToExtn Linux and Open Source 0 10-16-2007 11:07 AM
Excel 2007 bug 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.

» More about our Communities

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

Copyright 2002-2015 Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 03:25 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.