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

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
Thread Tools Display Modes
Old 04-25-2008, 09:04 PM   #1 (permalink)
Harper's Avatar
Join Date: Jan 2004
Location: Australia
Posts: 6,918

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)
HP zBook 14 - Intel Core i7 4600U (2.1 - 2.7 GHz), 16GB, 512GB SSD, 14" Display, Win 10 (64-bit)
Mobile Phone : Samsung Galaxy 8+Console : Play Station 4 Pro
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

Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 09:40 PM.

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