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, 10:04 PM   #1 (permalink)
Imperial Space Womble
 
Harper's Avatar
 
Join Date: Jan 2004
Location: Australia
Posts: 6,903
Question

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
Harper is offline  
Old 04-26-2008, 04:42 PM   #2 (permalink)
Monster Techie
 
Join Date: May 2004
Location: /usr/root/mn/us
Posts: 1,118
Default

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!!!!
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 05:44 PM
Amortization table in Excel Emper0r Programming 1 01-30-2008 09:38 PM
Curiosity with Excel 2000 Vegeeta Microsoft Windows and Software 2 01-21-2008 09:54 AM
Calc to Excel & vice verca cell protection hash CntdwnToExtn Linux and Open Source 0 10-16-2007 12:07 PM
Excel 2007 bug superdave1984 Microsoft Windows and Software 0 09-26-2007 11:48 AM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 09:19 AM.


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