View Full Version : Microsoft Excel Question;
Wildcat
10-06-2003, 06:39 PM
for a lab assignment of mine;
1. Calculate the mark up using a logical formula. Stock get different mark ups depending on their stock number. (3 marks)
a. If the stock number starts with a 1 the mark up is 35%.
b. If the stock number starts with a 2 the mark up is 45%.
c. If the stock number starts with a 3 the mark up is 40%.
my formula so far... i missing one thing but i dont know what :banghead:
=IF(A$3>"20000","35%",IF(A$3<"20000","45%",IF(A$3<"30000","40%")))
Wildcat
10-06-2003, 06:49 PM
probly need this too...
Wildcat
10-06-2003, 06:53 PM
any ideas? im stumped..
FallenAngel
10-07-2003, 12:18 AM
...i think you may have some of those backwards...
a. If the stock number starts with a 1 the mark up is 35%.
b. If the stock number starts with a 2 the mark up is 45%.
c. If the stock number starts with a 3 the mark up is 40%.
So that means that if the number is LESS than 20000, it should be 35%. You've got it set to 35% if it's GREATER than 20000.
I would probably specify above 30000 and below 20000, and just leave everything in between as ELSE. So something like this:
=(IF(A$3<"20000","35%"),IF(A$3>"29999","40%"),ELSE(45%))
I have no idea if that works or not, since I don't have the Excel spreadsheet in front of me. But I think you get the idea.
Note: I don't use Excel that much, so don't just copy this and expect it to work. I'm just trying to explain what I think might be a solution.
kaput
10-07-2003, 12:33 AM
.
Wildcat
10-08-2003, 12:42 PM
'ELSE' isnt a function, but thanks for trying tho :thumbsup:
and the dollar signs are so the information can be copied and applied to the entire colum, i handed the assinment in, i think itll work itself out... thanks
kaput
10-08-2003, 07:44 PM
.
Matthew
10-14-2003, 09:49 PM
Here is the function you need.
=IF(LEFT(A3,1)="1",.35,IF(LEFT(A3,1)="2",.45,IF(LEFT(A3,1)="3",.40)))
-Matthew
Wildcat
10-15-2003, 11:47 AM
Originally posted by Matthew
Here is the function you need.
=IF(LEFT(A3,1)="1",.35,IF(LEFT(A3,1)="2",.45,IF(LEFT(A3,1)="3",.40)))
-Matthew
that gives me it in a decimal, not the percentage, i tried modifying it to produce a percentage but it still dished out decimals.. its close though..
Matthew
10-15-2003, 09:16 PM
For God's sake, try Format->Cells "Percentage".
-Matthew
Wildcat
10-15-2003, 11:06 PM
Originally posted by Matthew
For God's sake, try Format->Cells "Percentage".
-Matthew
the prof wants percentages to appear based soley on the formula, i dont make the rules man
Powered by vBulletin® Version 4.2.4 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.